DUH oh yeah.....ver 5.5 ...with the version of the BDE that comes wiht D5.
Cheers, Jeremy Coulter
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Nic Wise
> Sent: Tuesday, 18 April 2000 09:57
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Interbase problem??
>
>
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz