jahlxx Posted June 6, 2016 Share Posted June 6, 2016 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. Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted June 6, 2016 Administrators Share Posted June 6, 2016 Can you share the exact number of rows loaded and time needed to load? Is your uniDBGrid in paged mode? Thanks Quote Link to comment Share on other sites More sharing options...
jahlxx Posted June 6, 2016 Author Share Posted June 6, 2016 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. Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted June 6, 2016 Administrators Share Posted June 6, 2016 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. Quote Link to comment Share on other sites More sharing options...
jahlxx Posted June 6, 2016 Author Share Posted June 6, 2016 How can I sort? I've tested and I can't. Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted June 6, 2016 Administrators Share Posted June 6, 2016 Please see one of our related demos. You must sort your data on server side. Quote Link to comment Share on other sites More sharing options...
jahlxx Posted June 6, 2016 Author Share Posted June 6, 2016 is postgres best choice than firebird? I could hav a high amount of data. Quote Link to comment Share on other sites More sharing options...
Skepsis IT Posted June 6, 2016 Share Posted June 6, 2016 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; Quote Link to comment Share on other sites More sharing options...
jahlxx Posted June 6, 2016 Author Share Posted June 6, 2016 yes. runs in debian 7 64 bits in a dedicated server. could be a firebird instancr in a similar server faster than postgres? Quote Link to comment Share on other sites More sharing options...
rencarnacion Posted June 6, 2016 Share Posted June 6, 2016 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 Quote Link to comment Share on other sites More sharing options...
jahlxx Posted June 6, 2016 Author Share Posted June 6, 2016 sorry farshad. wich demo? I can't find. what do you mean with : "You must sort your data on server side." ? Quote Link to comment Share on other sites More sharing options...
ZigZig Posted June 6, 2016 Share Posted June 6, 2016 Demoes are in "Demo" folder when you install uniGUI : C:\Program Files (x86)\FMSoft\Framework\uniGUI\Demos. Quote Link to comment Share on other sites More sharing options...
jahlxx Posted June 6, 2016 Author Share Posted June 6, 2016 yes, I know. but, in what demo can I see sort data on server side? thanks. Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted June 6, 2016 Administrators Share Posted June 6, 2016 Demo named: ..\GridColumnSort Quote Link to comment Share on other sites More sharing options...
jahlxx Posted June 6, 2016 Author Share Posted June 6, 2016 ok. work if grid is not paged, but not work if grid is paged Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted June 7, 2016 Administrators Share Posted June 7, 2016 It works if grid is paged or not. Have you tested it? Quote Link to comment Share on other sites More sharing options...
jahlxx Posted June 7, 2016 Author Share Posted June 7, 2016 ok. it works. is different, depends of what database, but works. thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.