Subject | RE: [IBO] IBOQuery Prepare |
---|---|
Author | Jason Wharton |
Post date | 2004-07-22T01:23:43Z |
You are most likely running into metadata queries. It might be possible to
put an index on your metadata that could speed this up. Another route would
be to use a schema cache file so that instead of getting the information it
needs from the server it will just pull it out of a local text file. This is
a property on the TIBODatabase component or TIB_Connection component.
HTH,
Jason Wharton
-----Original Message-----
From: Marv cook [mailto:mjcook@...]
Sent: Monday, July 19, 2004 7:32 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] IBOQuery Prepare
Hi all,
I am accessing a Firebird (1.5) DB across a very slow connection (375k)
and when I prepare a TIBOQuery it takes 7 seconds. Seems very long. A
TIB_Query takes about 1 second. Is there any way to avoid the prepare
each time the program starts up?
TIA
Marv
put an index on your metadata that could speed this up. Another route would
be to use a schema cache file so that instead of getting the information it
needs from the server it will just pull it out of a local text file. This is
a property on the TIBODatabase component or TIB_Connection component.
HTH,
Jason Wharton
-----Original Message-----
From: Marv cook [mailto:mjcook@...]
Sent: Monday, July 19, 2004 7:32 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] IBOQuery Prepare
Hi all,
I am accessing a Firebird (1.5) DB across a very slow connection (375k)
and when I prepare a TIBOQuery it takes 7 seconds. Seems very long. A
TIB_Query takes about 1 second. Is there any way to avoid the prepare
each time the program starts up?
TIA
Marv