Is it possible to get query result faster? Thanks

X

xpengi

Hi,

i build some crosstab queries in my code, it takes about 15 seconds t
get query result when running in my application system.

could it be speed up in software way?

thank
 
J

John Vinson

Hi,

i build some crosstab queries in my code, it takes about 15 seconds to
get query result when running in my application system.

could it be speed up in software way?

thanks
Click to expand...

Be certain that you have an Index on any fields that you are using for
sorting, grouping, or for criteria; and use Tools... Options to *turn
off* Name Autocorrect in your database. That should help, but a
complex many-row crosstab may just be slow; it's got to do a lot of
work!

John W. Vinson[MVP]
 
Top