It's been a long day. :-(
I've been having a problem with Interbase and threads. Got a little demo
where when I iterate through a table in two different threads (different
queries, databases and sessions), the threads hang (deadlock?) in the first
500 records. Doesn't happen with a local sql database, either, only with
Interbase (5K source available on request :-) ).
During my investigation of this, I found that the performance of Interbase
while scrolling down a grid ground to a halt when traversing a table with a
lot of indexes on it. Stepping from the 71st to the 72nd record in the
query (no relation to the size of the grid or the size of the datalink)
causes a delay of about 1 to 2 seconds, just long enough to be annoying.
Ditto when you step to the 144th record, et al.
Thinking my indexes may be stuffed, I attempted to backup and restore my
database. Then spent my time recreating said database, as discussed, and
berating the Interbase newsgroup. :-[
Is it Friday yet?
Cheers,
Carl
-----Original Message-----
From: Nic Wise [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 19 April 2000 4:54 PM
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase problem??
Odd - the old one (5.6) works just fine - if you say metadata = false (ie,
the default), you get everything - all structures, data, stored procs,
triggers, definitions for indexes (but not the index - its rebuilt) etc.
I'm guessing a big in 6.0b.
:)
N
--
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 Carl Reynolds
> Sent: Wednesday, 19 April 2000 18:39
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Interbase problem??
>
>
> 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
>
---------------------------------------------------------------------------
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
