Using the Unidirectional property (which should also be on the TIBOQuery
component) should be just fine. You will need to use this if you are going
to make use of 3rd party components which expect you to work via a TDataset
based component. It will only be slightly slower than the TIB_Cursor
component and it will carry a little bit larger memory footprint, but not
enough to worry about I don't think.

A common thing people do is use the AssignSQLWithSearch( ) method so that
they can allow people to use the nice search mode feature of the TIB_
components and then be able to easily run a report through the same dataset
via a TIBOQuery component (which is TDataset based).

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <tashi@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, November 07, 2001 1:55 PM
Subject: Re: [IBO] Component Compatibility


> This part of the application typically several hundred records but
> can get upwards of 20 - 25 thousand. Another part of the application
> not yet complete can get to 600,000+ records.
>
> For those of you whom may think I've flipped as to why I would do an
> application that would allow that many records to be retrieved, let
> me explain.
>
> This application is for the Financial Data for all the Community
> Colleges in Illinois. Chief Financial Officers of the colleges want
> to query the database for multiple colleges information and save that
> data on their own systems (Database, Spreadsheets, etc.) for their
> own analysis and studies.
>
> Although the application does have standard Financial Reports, I have
> been tasked to give them the ability to retrieve any inforamtion they
> want, no matter how much, in whatever format they need to work on
> their own systems.
>
> Later applications will be built accessing millions of records
> (Student Records, with 1 million+ added every year). In reading the
> Which component should I use in the IBO Help file. I gather I should
> use the (IB_) components wherever I can, one for functionality, two
> for speed. Which is what I'm looking for in all my Applications.
>
> The help file also states that in the unidirectional for IB_Query
> (there was no unidirectional help for IBOQuery) "if possible, to use
> the TIB_Cursor component and thus avoid the overhead of the buffering
> layer.", will this ba a major issue for me later with the large
> amounts of data?
>
> Thanks again
> Kevin