|Subject||Re: [IBO] Component Compatibility|
Excellent! Jason comes thru again.
--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> Using the Unidirectional property (which should also be on the
> component) should be just fine. You will need to use this if you
> to make use of 3rd party components which expect you to work via a
> based component. It will only be slightly slower than the TIB_Cursor
> component and it will carry a little bit larger memory footprint,
> enough to worry about I don't think.
> A common thing people do is use the AssignSQLWithSearch( ) method
> they can allow people to use the nice search mode feature of the
> components and then be able to easily run a report through the same
> via a TIBOQuery component (which is TDataset based).
> Jason Wharton
> CPS - Mesa AZ
> ----- Original Message -----
> From: <tashi@f...>
> To: <IBObjects@y...>
> 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
> > 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
> > application that would allow that many records to be retrieved,
> > me explain.
> > This application is for the Financial Data for all the Community
> > Colleges in Illinois. Chief Financial Officers of the colleges
> > to query the database for multiple colleges information and save
> > data on their own systems (Database, Spreadsheets, etc.) for their
> > own analysis and studies.
> > Although the application does have standard Financial Reports, I
> > been tasked to give them the ability to retrieve any inforamtion
> > 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
> > Which component should I use in the IBO Help file. I gather I
> > use the (IB_) components wherever I can, one for functionality,
> > 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
> > the TIB_Cursor component and thus avoid the overhead of the
> > layer.", will this ba a major issue for me later with the large
> > amounts of data?
> > Thanks again
> > Kevin