Jeremy
Does count(*) do the same thing? it usually is more efficient as
it is the std method for returning the size of a db
Just thinking that count(id) may use a method that can return a distinct
count
Random muses on the workings of sql parsers that may help
Regards Neven
N.K. MacEwan B.E. E&E
[EMAIL PROTECTED]
----- Original Message -----
From: Jeremy Coulter <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Tuesday, 18 April 2000 09:28
Subject: [DUG]: Interbase problem??
> Hi all.
>
> We have a wee utility that will generate 64,000 records and put them into
> our interbase db.
> Thats fine. BUT when we doa select count(id) from TheTable it takes ages
to
> come back, infact I have been waiting arounf 15mins for the data to
comback
> as I type this.
> The problem happens on both our server and local servers.
>
> The weired thing is, if we doa backup (via interbase) and restore it, its
> fine !
>
> I suspect that our indexing is gettinging out of wack, but we only have
PK's
> and FK's on the fields.
>
> Has anyone had this issue before, or got any suggestions ??
>
> Cheers, Jeremy Coulter
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
