Accelerate TADOQuery

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

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Vladimir Stefanovic Wed, 20 Apr 2005 20:58

#787

Author: Vladimir Stefanovic
Date: Wed, 20 Apr 2005 20:58

15 lines
1176 bytes

Hi,

I have one alone table in MS ACCESS database. Table is
about 300,000 records.

Then I dynamically create the SQL query for TADOQuery
to retreive top 15 matching records. I *am* satisfied with
speed, but I'm curious can some changing of TADOQuery
properties speed up the query yet more?



-- 
Best regards,
Vladimir Stefanovic

Re: Accelerate TADOQuery

#788

Author: Viatcheslav V. Vassiliev
Date: Thu, 21 Apr 2005 06:34

28 lines
1779 bytes

Good indexes in Access database could.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Vladimir Stefanovic" <antivari@po.sbb.co.yu> �������/�������� � �������� 
���������: news:4266c273@newsgroups.borland.com...
> Hi,
>
> I have one alone table in MS ACCESS database. Table is
> about 300,000 records.
>
> Then I dynamically create the SQL query for TADOQuery
> to retreive top 15 matching records. I *am* satisfied with
> speed, but I'm curious can some changing of TADOQuery
> properties speed up the query yet more?
>
>
>
> -- 
> Best regards,
> Vladimir Stefanovic
>

Re: Accelerate TADOQuery

#789

Author: Vladimir Stefanovic
Date: Fri, 22 Apr 2005 15:58

38 lines
2058 bytes

Thanks.


-- 
Best regards,
Vladimir Stefanovic
"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message 
news:42674981@newsgroups.borland.com...
> Good indexes in Access database could.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Vladimir Stefanovic" <antivari@po.sbb.co.yu> �������/�������� � �������� 
> ���������: news:4266c273@newsgroups.borland.com...
>> Hi,
>>
>> I have one alone table in MS ACCESS database. Table is
>> about 300,000 records.
>>
>> Then I dynamically create the SQL query for TADOQuery
>> to retreive top 15 matching records. I *am* satisfied with
>> speed, but I'm curious can some changing of TADOQuery
>> properties speed up the query yet more?
>>
>>
>>
>> -- 
>> Best regards,
>> Vladimir Stefanovic
>>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads