... :)
Cheers,
Carl
-Original Message-
From: Carl Reynolds [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 19 April 2000 5:26 PM
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase problem??
It's been a long day. :-(
I've been having a problem with Interbase and threads
There's another issue with Interbase that people considering a
change should
be aware of. Interbase's performance when using TTables through
the BDE is
absolutely abysmal.
Um, as far as I know, this is a problem with ANY SQL-based DB (oracle et
al). It comes from
doing
select * from
itten".
But one tenth as fast?! Do other sql dialects suffer this bad? It should
be shouted from the rooftops...
Cheers,
Carl
-Original Message-
From: Nic Wise [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 27 April 2000 11:49 AM
To: Multiple recipients of list delphi
Subject: RE: [DUG
Um, as far as I know, this is a problem with ANY SQL-based DB (oracle et
al).
There's abysmal and then there's merely appalling. :)
What surprised me is that a simple "select * from tablename" TQuery
performed so much better than an equivalent TTable, in Interbase. Can't
really compare
Carl Reynolds asked:
Um, as far as I know, this is a problem with ANY SQL-based DB
(oracle et al).
There's abysmal and then there's merely appalling. :)
What surprised me is that a simple "select * from tablename" TQuery
performed so much better than an equivalent TTable, in Interbase.
Max wrote:
Carl Reynolds asked:
Um, as far as I know, this is a problem with ANY SQL-based DB
(oracle et al).
There's abysmal and then there's merely appalling. :)
What surprised me is that a simple "select * from tablename" TQuery
performed so much better than an equivalent
Re
TTable and and SQL server are an anathema
TTable is based on a 'Database File' and Indexes (indicies sp) - ANSII SQL
doesn't expose indexes
(though almost every implementation does and ODBC requires it)
The history of TTable is inseparately linked with the BDE (which as you will
recall was
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
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
Works fine in IB5.6.
-Original Message-
From: Carl Reynolds [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 6:39 PM
To: Multiple recipients of list delphi
Subject:RE: [DUG]: Interbase problem??
File: ATT2.txt; charset = windows-1252
application/ms-tnef
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
which version of interbase?!
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
DUH oh yeah.ver 5.5 ...with the version of the BDE that comes wiht D5.
Cheers, Jeremy Coulter
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Nic Wise
Sent: Tuesday, 18 April 2000 09:57
To: Multiple recipients of list delphi
Subject: RE: [DUG
Jeremy
Does count(*) do the same thing? it usually is more efficient as
it is the std method for returning the size of a db
Just thinking that count(id) may use a method that can return a distinct
count
Random muses on the workings of sql parsers that may help
Regards Neven
N.K. MacEwan B.E.
- Original Message -
From: Andrew Masters [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Tuesday, 18 April 2000 13:17
Subject: RE: [DUG]: Interbase problem??
You should always do a backup/restore after any large data manipulation.
What
]]On
Behalf Of Neven MacEwan
Sent: Tuesday, 18 April 2000 14:53
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Interbase problem??
- Original Message -
From: Andrew Masters [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Tuesday, 18 April
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
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
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
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
20 matches
Mail list logo