Subject | Re: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-05-24T08:52:56Z |
Sorry to hear that you still have this problem, Enrico. Just a couple
of questions that may or may not have been asked already:
Is AutoFetchAll set to false?
Have you tried using SchemaCache (and SchemaCacheDir) for the
connection component (I think it will only help on the second
execution)?
A long time ago, Alexander Nevsky used to encourage creating an index
on a system table if you had lots of tables etc. within your database.
I think this later got included in Firebird, but if you're still on a
very old version, then maybe that can help (sorry, I don't remember
which table).
Set
of questions that may or may not have been asked already:
Is AutoFetchAll set to false?
Have you tried using SchemaCache (and SchemaCacheDir) for the
connection component (I think it will only help on the second
execution)?
A long time ago, Alexander Nevsky used to encourage creating an index
on a system table if you had lots of tables etc. within your database.
I think this later got included in Firebird, but if you're still on a
very old version, then maybe that can help (sorry, I don't remember
which table).
Set
--- In IBObjects@yahoogroups.com, "Enrico Raviglione" wrote:
> Hi Jason,
> Now we are arrived at 24.05.2005, my first e-mail are dated
> 18.03.2005 then i must know if you can do something about this
> problem.
> If i can help you in any manner tell me what i must do ...
> My time are finished ...
>
> Best Regards.
>
> Enrico Raviglione