Subject | Very long prepare time |
---|---|
Author | Heiko Tappe |
Post date | 2003-02-26T16:22:31Z |
I posted a message to b.p.interbase.general last day
(See thread: Weird foreign key performance problem)
I am not sure, but I think it should also be posted at some more FB specific
group, because same problems encountered with FB 1.
Is this the right place? I couldn't find anything more FB specific.
So as a summary: after connection is established the first time
a select is prepared, FB1/IB6 needs several seconds (1.6 to 6.0 s)
to return. And it's not a very complicated command:
SELECT ID FROM SomeTable
More on that in b.p.i.g
--Heiko
(See thread: Weird foreign key performance problem)
I am not sure, but I think it should also be posted at some more FB specific
group, because same problems encountered with FB 1.
Is this the right place? I couldn't find anything more FB specific.
So as a summary: after connection is established the first time
a select is prepared, FB1/IB6 needs several seconds (1.6 to 6.0 s)
to return. And it's not a very complicated command:
SELECT ID FROM SomeTable
More on that in b.p.i.g
--Heiko