Telegram_2023-09-06T22

<< Click to Display Table of Contents >>

Navigation:  Telegram > 2023 > 09 > 06 >

Telegram_2023-09-06T22

Telegram link

 

2023-09-06T22:12:50

 

that make me complains from limit number if users with my application

 


 

Telegram link

 

2023-09-06T22:14:21

 

I test my application for memory leak with memory leak program integrated with my delphi show no memory leak

 


 

Telegram link

 

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

 


 

Telegram link

 

2023-09-06T22:18:35

 

I am try to find best hardware and database spect. in which can improve my application

 


 

Telegram link

 

2023-09-06T22:22:17

 

I want to get a message with yes or no before complete actions

 


 

Telegram link

 

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.

 


 

Telegram link

 

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

 


 

Telegram link

 

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

 


 

Telegram link

 

2023-09-06T22:45:46

 

Yes, this is important

 


 

Telegram link

 

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