which version of interbase?!
N
--
Nic Wise - 021.676.418 / [EMAIL PROTECTED] / Inprise/Borland New Zealand
Is it not a foolish man, said little Woo, who keeps all his chickens in his
trousers?
For at best, will he not suffocate his chickens, and, and worst, will he not
disappoint the ladies in the village? --Alexi Sayle
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Jeremy Coulter
> Sent: Tuesday, 18 April 2000 09:29
> To: Multiple recipients of list delphi
> 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
