Andy Colson wrote:
Nico Callewaert wrote:
Hi List,
I tried already in the ODBC list, but without success...
I have to develop a client/server application, heavily transaction
oriented, that will serve around 100 users and database traffic will
be intense (lot's of reads, updates, inserts....).
Development environment is Delphi 2007. I know there are a few
commercial components available, but I was wondering if ODBC could do
the job ? So, my question is, if ODBC is intended to be used for that
? Many simultanous connections, lots of inserts, updates ?
The thing you always hear about ODBC is, that it is very slow ?
Many thanks in advance,
Best regards,
Nico Callewaert
I don't know about odbc, never used it to hit PG. I use Delphi and
wrote a simple object on top of the libpq api. The api is simple to
use. If odbc doesn't work out for you I'd recommend using libpq direct.
I have using an older Delphi (v3), ODBC itself I believe was fine but
the BDE layer introduced problems- apps needed to be rebooted evey month
or so.
Note that ODBC doesn't easily support any non-standard facilities, e.g.
listen/notify.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
