Thanks to all who replied !
We have NOT isolated the problem,, but then it all turned to custard
yesterday and we didn't get a chance to investigate more.
Will keep you informed,
Jeremy Coulter
> -----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
