Subject | RE: [IBO] would i get better performance with TIB_Cursor ??? |
---|---|
Author | Jason Wharton |
Post date | 2006-06-27T06:04:30Z |
TIB_Cursor is faster because it is much more simple than TIBOQuery. To
operate a fully fleshed out TIBOQuery there are actually multiple internal
TIB_Cursor (TIB_Dataset) component instances to make everything work.
Granted if you are only selecting data they aren't going to be utilized.
The nicest difference is you will use a lot less memory because the
TIB_Cursor doesn't buffer the records fetched.
Jason
operate a fully fleshed out TIBOQuery there are actually multiple internal
TIB_Cursor (TIB_Dataset) component instances to make everything work.
Granted if you are only selecting data they aren't going to be utilized.
The nicest difference is you will use a lot less memory because the
TIB_Cursor doesn't buffer the records fetched.
Jason
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Carlos GarcĂa Trujillo
> Sent: Friday, June 23, 2006 5:44 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] would i get better performance with TIB_Cursor ???
>
>
> My question is if i woulds get better performance in a Report Builder
> Report using TIB_Cursor instead of a TIBOQuery...
>
> If this is true how much better performance??? i've seen in
> documentation that in unidirectional datasets IB_Cursor's are faster
> than IBOQuery's and IB_Query's, why is that are faster??? does they
> use Direct API to request the data????
>
> Thanx in advance =:-)