Re: COUNT(*) problem

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

Article #3560

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

#3560

From: Michael Crapo
Date: Thu, 01 Aug 2002 17:35

21 lines
1584 bytes

You can look in the system table that holds that information.

select rowmodctr from sysindexes where Name = '{table name}'

Mike

On Thu, 1 Aug 2002 10:00:59 +0200, "Robert Lancaster"
<robert.lancaster@thales-geosolutions.com> wrote:

>Greetings,
>
>I am using a Microsoft SQL Server 6.5 database. In my database there is a
>table with 2,700,000 rows. Doing a COUNT(*) on this table in Query Ananlyser
>takes 25 minutes. If I try and execute this query using a TADOQuery
>component the driver times out. Is there any quicker way of doing this or is
>there a quickewr way of getting the row count.
>
>Thanks,
>
>Robert Lancaster
>

Technical Details

Message-ID: <WnFJPf=2iJMNYQ70woKSO6Prhiby@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!diablo.theplanet.net!newsfeed.esat.net!lnewspeer01.lnd.ops.eu.uu.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!dnews!not-for-mail

References: <3d48ebaa_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d90ad75fb42042a7
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-08-01 09:43:34 PST
From: Michael Crapo <mikec@docutechcorp.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: COUNT(*) problem
Date: Thu, 01 Aug 2002 11:35:23 -0600
Message-ID: <WnFJPf=2iJMNYQ70woKSO6Prhiby@4ax.com>
References: <3d48ebaa_2@dnews>
X-Newsreader: Forte Agent 1.6/32.525
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 208.178.101.226
X-Trace: dnews 1028219646 208.178.101.226 (1 Aug 2002 09:34:06 -0700)
Lines: 22
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!diablo.theplanet.net!newsfeed.esat.net!lnewspeer01.lnd.ops.eu.uu.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!dnews!not-for-mail

Reply to Parent Message