You neglected to mention that only the database structure gets backed up,
even if you choose "Metadata only = false". Then when you restore, you blow
away all your data. Nice feature, that.
Or at least that's what happens here using IB6. And this has been the least
of the issues I've found. Interbase is starting to get right up my nose.
:o[
Cheers,
Carl
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 18 April 2000 11:18 AM
> 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
