> 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 ??
I don't know about Interbase but ORACLE has storage specifiers for the table at
creation time.
These specifiers assist ORACLE in avoid fragmentation... The same goes for Indexes
IIRC...
Are similar storage specifiers (Inital extent, next extent, clustering) available in
Interbase.
--
Aaron@home
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
