Subject | Lots of TIB_Cursors/TIB_Queries |
---|---|
Author | Aage Johansen |
Post date | 2001-01-10T21:14:31Z |
Is there a penalty for having a DataModule with a _lot_ of TIB_Cursors
(most or all of which are prepared) - memory requirements or other issues?
I have 50+ SQL queries that I use for validating input data. Currently I
use just a few TIB_Cursors where I replace the SQL
(Clear/Add/Prepare/... plus links) all the time. I would guess that
having separate TIB_Cursors which are kept prepared would be somewhat
faster, but have not yet tried this approach.
TiA
Aage J.
(most or all of which are prepared) - memory requirements or other issues?
I have 50+ SQL queries that I use for validating input data. Currently I
use just a few TIB_Cursors where I replace the SQL
(Clear/Add/Prepare/... plus links) all the time. I would guess that
having separate TIB_Cursors which are kept prepared would be somewhat
faster, but have not yet tried this approach.
TiA
Aage J.