Thanks for responding,
I suppose what I was really asking is if PostGreSQL works 'as good' as
other databases like Oracle. The rumour I heard implied that I would have
problems trying to run PostGreSQL with a lot of clients
As for the queries:
I have a 6000 record customer file and a bigger file containing orders
The VB programs randomly retrieved records with a like clause on the first
letter of the customer name
E.G. B%, F%, Z%. This SQL also had a join to the order file and returned a few
hundered records at a time
The slow SQL I entered simply returned the MAX value for a column in the order
file. This did seem to lock things
down, perhaps p-sql was just being cautious or maybe it just slowed everything
down quite a lot?
Thanks a lot,
M Chantler
--
NOTICE: The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or entity
to which it is directed and may contain information that is privileged or
otherwise confidential. If you have received this electronic mail transmission
in error, please delete it from your system without copying or forwarding it,
and notify the sender of the error by reply email or by telephone (collect), so
that the sender's address records can be corrected.