Slow query retrieval

Article View: borland.public.cppbuilder.database.ado

Article #2693

Back to borland.public.cppbuilder.database.ado Previous Next

#2693

From: Ian Grainger
Date: Tue, 08 Apr 2003 11:56

25 lines
1865 bytes

Hi,

I'm experiencing speed problems retrieving data from a customers database
that uses an Ingres 6.4 server. I'm connecting to the database using the
Microsoft ADO driver for ODBC. The ODBC driver for the Ingres server is
provided by OpenLink. It is the only driver I have been able to source (any
other suggestions?).

I have tried setting my cursor to work on the server side, but this causes
problems when issuing statement that returns NULL values. Basically the
query operation is halted and returns no rows!!

I cannot get the GetTableNames service to work when using server side
cursors either. Is this a clue?

When I use the client side cursor, the complete query result set is
transferred to the client machine - which is slow - even when using
DisableControls (although this did speed events up considerably).

Can anyone suggest why the server side operations don't work?

Thanks.

--
Ian Grainger

Technical Details

Message-ID: <3e92b979@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9fe5ea31d31cefc,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-04-08 05:24:02 PST
From: "Ian Grainger" <ig@shl.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Slow query retrieval
Date: Tue, 8 Apr 2003 12:56:11 +0100
Lines: 27
Organization: Smiths Aerospace
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 62.190.103.177
Message-ID: <3e92b979@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1049803129 62.190.103.177 (8 Apr 2003 04:58:49 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail