Re: COUNT(*) problem

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

Article #3488

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

#3488

From: Tim
Date: Mon, 05 Aug 2002 14:38

29 lines
1792 bytes

CAUTION: number is only accurate after an "update statistics"


"Michael Crapo" <mikec@docutechcorp.com> wrote in message
news:WnFJPf=2iJMNYQ70woKSO6Prhiby@4ax.com...
> 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: <3d4e8c0f$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!not-for-mail

References: <3d48ebaa_2@dnews> <WnFJPf=2iJMNYQ70woKSO6Prhiby@4ax.com>

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-05 07:48:46 PST
Reply-To: "Tim" <timsmith_s@yahxxoo.dot.com>
From: "Tim" <timsmith_s@yahxxoo.dot.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d48ebaa_2@dnews> <WnFJPf=2iJMNYQ70woKSO6Prhiby@4ax.com>
Subject: Re: COUNT(*) problem
Date: Mon, 5 Aug 2002 09:38:46 -0500
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: 12.248.162.212
Message-ID: <3d4e8c0f$1_2@dnews>
X-Trace: dnews 1028557839 12.248.162.212 (5 Aug 2002 07:30:39 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!not-for-mail

Reply to Parent Message