Subject | Slow SELECT in TIBOQuery - Default values |
---|---|
Author | bjorgeitteno <bjorge@itte.no> |
Post date | 2003-02-04T09:26:26Z |
Hi !
I've had problems with slow initial selects with TIBOQuery. I located
the problem in the routine where Default values are loaded from RDB$
tables. This operation gives no meaning whatsoever in my application,
as the query is ReadOnly.
- Is there a straightforward way to disable this slow operation when
it's not needed (for now I've modified the code to exit this
procedure), or do I need to implement a new property to control it ?
- Is there a more sophisticated DBGrid out there that works with
TIB_Cursor ? Or - is TIB_Cursor a bad idea for having a scrollable
dataset displayed in a grid ?
If so, is there any advantages with using a TIB_Query over a
TIBOQuery when result set is displayed in a grid ?
Thanks in advance !
BTW, is it possible to post messages to this group...
- directly from email app ?
- through atkin news server ?
Regards,
--
Bjørge Sæther
bjorge@hahaha_itte.no
I've had problems with slow initial selects with TIBOQuery. I located
the problem in the routine where Default values are loaded from RDB$
tables. This operation gives no meaning whatsoever in my application,
as the query is ReadOnly.
- Is there a straightforward way to disable this slow operation when
it's not needed (for now I've modified the code to exit this
procedure), or do I need to implement a new property to control it ?
- Is there a more sophisticated DBGrid out there that works with
TIB_Cursor ? Or - is TIB_Cursor a bad idea for having a scrollable
dataset displayed in a grid ?
If so, is there any advantages with using a TIB_Query over a
TIBOQuery when result set is displayed in a grid ?
Thanks in advance !
BTW, is it possible to post messages to this group...
- directly from email app ?
- through atkin news server ?
Regards,
--
Bjørge Sæther
bjorge@hahaha_itte.no