Oh, so there is no Interbase API call or anything?
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 18 April 2000 16:14
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Interbase problem??
>
> Yes, it can. Just remember you can't be connected when you do the restore.
> It's a handy thing to do for clients who are not in an environment where
> there is a system administrator.
>
> I've got a small util that just calls GBAK.EXE with the appropriate params
> and does the some checking for any errors in the log file.
>
> -----Original Message-----
> From: Nahum Wild [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 18, 2000 1:57 PM
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Interbase problem??
>
> 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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz