well when using vb and queries always make sure there isnt a function that already does what your doing. try combine related queries through left joins but do not combine too many that will all together slow down the entire query. also always try to cache table from table to another so you dont have to query another table when you could have cached the data from the beginning, i.e. anything to do with counting entries could easily be cached instead of having to query a table and counting x rows.
02-01-2005, 01:10 AM
Linear Mode
