It's okay not to know all the answers. It's better to admit our ignorance than to believe answers that might be wrong. Pretending to know everything closes the door to finding out what's really there.
Do you have any material that can help with optimizing queries and also the formulas that we put in queries? I have a fairly complex DB that I'm just finishing and have some queries that I had to use several levels of other queries to build with dozens of formulas and the query/form now takes a few seconds to load on a good computer. I have only about 1500 records in it right now, so I'm nervous that it will only get worse.
Kevin Yip
@Reply 4 years ago
With only 1500 records, queries should run instantaneously. "Optimization" in your case will likely involve redesigning some of the queries, which will be tough to do on complex queries. So don't let them get too complex. Find ways to break them up into simpler ones. Post some of your SQL statements here to see what we are dealing with. Also, SQL Server has a more powerful SQL system, so you may consider that, but it isn't magic.
Kevin Yip
@Reply 4 years ago
Also, performance issues may not be all due to queries. Tables not designed properly could slow things down too, so does poor VBA coding.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
