You can not become a scientist if you require that every question has an answer because its the very questions that have no answer that attract you to a laboratory every single day.
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.
