Query Speed

[JPritch]

I query against a table with 380K records and growing.

There are approx 14 fields in the table, but I only retrieve 7 in my query. Does having those extra fields in there slow the query down, or does the query ignore them?

Just trying to figure out ways to improve speed.

Thanks.

 

[FoFa]

Well, when you query Access builds a temp recordset (sometimes many depending on your options like sorting etc). These temp recordsets of course take space in the DB. Now I don't know if these contain pointers to the actual data, or the actual data (I just know the internals that well). If these contain the actual data, then limiting the columns should give you a speed boost (not moving as much data). Why not just copy your query and limit the columns and bench mark both queries to see?

 

[Rich]

Are there any calculated fields in the query?