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.

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.