|Author||Topic: use of PGDBE|
|sudeep sharma||use of PGDBE|
on Wed, 28 Mar 2018 23:36:51 +0530
I am trying to use postgre SQL server 9.5 with xbase 2.0 with the help of datebase engine PGDBE. The performance is very poor in comparison of DBF/NTX datebase with ADS server. Can anybody help to sort out the problem.
|Otto Trapp||Re: use of PGDBE|
on Thu, 12 Apr 2018 11:22:37 +0200
Hello, Probably you created indices on the server side on columns that should increase speed. Unfortunately there is very little info on PGDBE from Xbase++ users and also from Alaska. Now I came accross my 2014.04.16 posts listing my test results, questions, concerns about PGDBE in the news group 'preview.xbase++.20' but the replies were very limited. Since then I did not test PGDBE, I waited feedbacks and a completed PGDBE documentation / reference. I see questions and suggestions to use ADS if one wants to speed up shared DBF access. For me ADS is not an option as my customers won't pay 8-10 times the price of our product just for a database engine. They want remote access, moderate hardware, high speed and low price. (Even if everyone knows you can't have everything, a wish list should be shortened). So PGDBE has its place if it is fast 'enough' (in my opinion a few times faster than shared dbf acces) and has the ability to run Xbase++ code on the server side (there were such plans, weren't there?) and this way intensive data processing (eg. creating reports from tens of thousands of records from different tables) could be done much much faster than on the client side. Such code could be relocated to the server side one-by-one and as needs require. If any of you have some experience with PGDBE, its speed, state, advantages / limitations or have answers to my 2014 posts, please let me know. Thanks. Best Regards, Otto 2018.03.28. 20:06 keltezéssel, sudeep sharma írta: > I am trying to use postgre SQL server 9.5 with xbase 2.0 with the help > of datebase engine PGDBE. The performance is very poor in comparison of > DBF/NTX datebase with ADS server. Can anybody help to sort out the problem.