Jump to content

Recommended Posts

Posted

Hi.

 

Loading Data in a unidbgrid expend many time, many more than in VCL app with the same select sentence.

 

I use postgresql with unidac components.

 

Any idea about how to configure the grid and / or the datasource?

 

Thanks.

 

Posted

Hi.

 

To load 1500 rows, takes 20 seconds. In vcl app (client / server), only 2 seconds. I can't understand this very big difference in performance. The amount of rows is insignificant.

 

In page mode, the load is very fast, but I loose the possibility of reorder the grid in title click.

Posted

Hi, firebird may be faster at read operations but at complex queries or write operations may be not. In general comparison of dbms is not that simple because many issues must be analysed to have a complete answer.

 

Additionally,

Does your postgre db runs on a linux machine;

Do you have a dedicated database server;

Posted

As far as I Know Postgres is World Class Database, 

PostGres is vying with Oracle, MySQL, MS SQL and the performace is one of the Best 

Other Advantage is  that Postgres can run in more platform  than Firebird 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...