Article View: borland.public.cppbuilder.database.ado
Article #1642Re: speed
From: Viatcheslav V. Vassiliev
Date: Thu, 04 Mar 2004 07:14
Date: Thu, 04 Mar 2004 07:14
29 lines
2058 bytes
2058 bytes
You say nothing about DBMS you are using, it is local or located in network and which components you are using (TDataSet is common abstract class). 1/20 sec. for one select usually is normal. Of course, you can speed up your application if you will use direct API for your DBMS. //------------------------------------------ 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) "C�sar" <kaesar2@lycos.es> �������/�������� � �������� ���������: news:c25unh$1q10bj$1@ID-201928.news.uni-berlin.de... > Hi, > I�m making a program that requires about 100 select clauses one after > each other. > It works well but it takes about 5 seconds, even when the database is almost > empty. Is it normal? or do you think i have a problem with my implementation > and still can speed up my application a lot? > I�m using the component TDataSet for the select clauses. > > Thanks in advance. > > >
Technical Details
Message-ID:
<4046d738$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<c25unh$1q10bj$1@ID-201928.news.uni-berlin.de>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,3402a080f58a807c X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2004-03-03 23:39:28 PST From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <c25unh$1q10bj$1@ID-201928.news.uni-berlin.de> Subject: Re: speed Date: Thu, 4 Mar 2004 10:14:06 +0300 Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 213.234.218.42 Message-ID: <4046d738$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1078384440 213.234.218.42 (3 Mar 2004 23:14:00 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail