Can this be done programmatically? or does someone actually have to manually
do it?
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 18 April 2000 13:18
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Interbase problem??
>
> A Backup/Restore rebuilds indexes and updates the statistics. You should
> always do a backup/restore after any large data manipulation.
>
> -----Original Message-----
> From: Jeremy Coulter [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 18, 2000 9:29 AM
> 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
