There is in 6.0 (beta :) ), but not in 5.x (I assume you mean for backup?)
for the index one, I think its an alter table. Bill Karwin's "10 ways to
make IB scream" has the details... if you can find it :)
N
http://www.interbase.com/downloads/makeibscream.pdf
--
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 Nahum Wild
> Sent: Tuesday, 18 April 2000 16:21
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Interbase problem??
>
>
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
