For the database challenged amongst us.........

Do not pull all the records back from a table or view and then do an ADO Filter operation.  This is typically a bad thing, causes too much network traffic, and is a general inefficient use of resources.  Lets not say “select * from table.”  Let's do at least a “select * from table where ........”  You could also do a “select col1, col2, col3, ... from table where ......” which would be even better.  Don't send too much info across the wire.  Don't use too many resources.  If you have some database experts in your development group, look into using stored procedures.  Oh the pain......Oh the agony.....

Wally

No Comments