unidbgrid

[jahlxx]

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.

 

[Farshad Mohajeri]

Can you share the exact number of rows loaded and time needed to load?

Is your uniDBGrid in paged mode?

 

Thanks

[jahlxx]

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.

[Farshad Mohajeri]

Loading 1500 rows in non-paged mode will be slower than VCL and it is quite normal.  You can still sort your grid in paged mode there is no difference.

[jahlxx]

How can I sort? I've tested and I can't.

[Farshad Mohajeri]

Please see one of our related demos. You must sort your data on server side.

[jahlxx]

is postgres best choice than firebird?

 

I could hav a high amount of data.

[Skepsis IT]

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;

[jahlxx]

yes. runs in debian 7 64 bits in a dedicated server.

 

could be a firebird instancr in a similar server faster than postgres?

[rencarnacion]

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 

[jahlxx]

sorry farshad.

 

wich demo? I can't find.

 

what do you mean with : "You must sort your data on server side." ?

[ZigZig]

Demoes are in "Demo" folder when you install uniGUI : C:\Program Files (x86)\FMSoft\Framework\uniGUI\Demos.

[jahlxx]

yes, I know.

 

but, in what demo can I see sort data on server side?

 

thanks.

[Farshad Mohajeri]

Demo named:

 

..\GridColumnSort

[jahlxx]

ok. work if grid is not paged, but not work if grid is paged

[Farshad Mohajeri]

It works if grid is paged or not. Have you tested it?

[jahlxx]

ok. it works.

 

is different, depends of what database, but works.

 

thanks.