Performance - What really matters?

[freedowsRoO]

Hello guys!! How you doing?

I've been testing some small applications to learn more about performance with Unigui but i want to know from you guys what is the best pratice to consuming less resource of the server side?

 

I tested 3 cases with 500 records with one DBGrid:

• Consuming an API and saving the data in a TFDMentable.
• Direct connecting in the local database with TFDQuery.
• Direct connecting in the local database but saving the data in a TFDMentable.

 

Using the stress test tool in all the 3 cases, the consuming off resources is pretty much the same. The big deal here is that with direct connecting the server side holds the memory until i close the TFDQuery and in the other tests i close the TFDQuery immediatly fetch the records on the TFDMentable realising the memory more fast than the others.

 

[Pep]

Another advantage of using "TFDMemtable" component is that you can close the connection with the data server to optimize resources and also you can use Pool Connections: http://docwiki.embarcadero.com/CodeExamples/Sydney/en/FireDAC.Pooling_Sample to make your applicaction more scalable.