[WD 23] Slow query execution ??

Hello everyone

What are your experiences with processing large amounts of data?
I have a few complex queries when a search starts it takes too long.
Sometimes it happens that the application stops working and then after restarting the server it works.
Shouldn't queries get the job done much faster?

I use HF Server and base and WD 23

My exe application is at 32 bits

Thank you

[infosonline.net]



Edited 1 time(s). Last edit at 02/10/2021 12:24PM by infos.

> Shouldn't queries get the job done much faster?

NO!

Queries WELL WRITTEN running against a DB with optimized key and logic will run fast...

Queries in general are no better than the coder creating them

And in ALL CASES, if you are asking a query to read 5 millions records, make calculations on them and then return 300000 records out of them, it will take time, no matter WHAT and how well optimized everything is. In a case like that, it's your process logic that needs to change.

So the LOGIC of your data access is the first problem to solve, then the query optimization with appropriate keys

Totally agree with that answer.

But if you post the query here, maybe someone with lots of query knowledge can see what you don't see.

Regards,

Carlos