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]