BobyIsProgress
Member
Hello Guys,
I have a performance/best practice question:
When doing an open-query for a browse I choose to go with my database table directly instead of compiling all the data in a temp-table first and display them after. It allows me the following:
1. No loading time
2. live update of data whilde browsing
3. low number of row load in browse buffer (arround 70)
But I will do a massive number of reading on the database.
Which is the better solution? Why? What is the limit to choose one on another ?
Best Regards,
BobyIsProgress
I have a performance/best practice question:
When doing an open-query for a browse I choose to go with my database table directly instead of compiling all the data in a temp-table first and display them after. It allows me the following:
1. No loading time
2. live update of data whilde browsing
3. low number of row load in browse buffer (arround 70)
But I will do a massive number of reading on the database.
Which is the better solution? Why? What is the limit to choose one on another ?
Best Regards,
BobyIsProgress
Last edited: