|
<< Click to Display Table of Contents >> Navigation: Telegram > 2023 > 09 > 06 > Telegram_2023-09-06T22 |
2023-09-06T22:12:50
that make me complains from limit number if users with my application
2023-09-06T22:14:21
I test my application for memory leak with memory leak program integrated with my delphi show no memory leak
2023-09-06T22:16:50
for my application to compete other application available I have to goes a bout 200 users online without any problem
2023-09-06T22:18:35
I am try to find best hardware and database spect. in which can improve my application
2023-09-06T22:22:17
I want to get a message with yes or no before complete actions
2023-09-06T22:34:47
The key is minimize DB access and use a local cache to reduce the number of queries. Like, a table that hardly changes, there is no need to query it every time for the same information. Cache it locally and use it. If possible develop a shared cache that can be consumed by all the sessions.
2023-09-06T22:44:15
A good example for this is a table that contains all the cities of a country. Let's say you have one of these.
If your table is complete, it won't change often, if ever. So instead of querying the city table every time to populate a \city\ combobox, just load them all into a memory table and use it from there. You can even store it in a local file between sessions and eventually check the DB for updates.
I created such a system long ago for a banking system and it worked pretty well. Was 100% based on TClientDataSets which work great for it
2023-09-06T22:45:03
Only fetch what you need when you need it. For example dont fetch blob data until you need it. Select * from db is bad idea
2023-09-06T22:45:46
Yes, this is important
2023-09-06T22:48:25
Yeah even how you have data for drop down lists. Can be shared globally not repeated in each user session