removing sort/filter from queries more easily?

[HM]

Greetings All,

I recently discovered how much sorts in queries slow down the running or a
query. Especially when compounded by several queries in series.

Is there a way to remove the sort from queries across the entire database
automatically? Right now, since I can't tell which queries may have
sorts on them, I have to run each related query (over 50) and remove the
sorts manually (Records / Remove Filter/Sort)?

Hopeing for a faster way.

Thanks,

Hanie

 

[[MVP] S. Clark]

Yes, but it would require knowing some basic VBA coding practices.

QueryDef.sql allows you to get to the string. Parsing out the ORDER BY
clause would be my method of choice, but it isn't easy to know when the
ORDER BY ends.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-