Subject | Re: [IBO] IOBQuery |
---|---|
Author | Hans |
Post date | 2005-03-08T06:24:21Z |
IBO does some very intelligent requests in most cases,
unless you turn the get me all the records flag on.
Also there is some incremental arti intelligence
build in for (inc) searches.
Forgot the names of them :)
unless you turn the get me all the records flag on.
Also there is some incremental arti intelligence
build in for (inc) searches.
Forgot the names of them :)
----- Original Message -----
From: "Robert martin" <rob@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 07, 2005 8:53 PM
Subject: Re: [IBO] IOBQuery
>
> Hi Hans
>
> Sorry, I should have said in my original email that I knew about the
> 'Select first x' syntax. I actually want all data available, but just
> want to know that IBO wasn't going to suck it down until required :)
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> Hans wrote:
>
>>maybe
>>
>>select first 100 * from table
>>
>>will satisfy your requirements ?
>>
>>----- Original Message -----
>>From: "Robert martin" <rob@...>
>>To: <IBObjects@yahoogroups.com>
>>Sent: Monday, March 07, 2005 2:56 PM
>>Subject: [IBO] IOBQuery
>>
>>
>>
>>
>>>Hi All
>>>
>>>Am I right in saying that when a query is run only a certain amount of
>>>data is transfered from the client machine to the server? Is this
>>>configurable, if so where?
>>>
>>>I have a query that returns 100,000 + records but normally only the
>>>first 100 or so would be of any interest.
>>>
>>>
>>>--
>>>Rob Martin
>>>Software Engineer
>>>
>>>phone +64 03 377 0495
>>>fax +64 03 377 0496
>>>web www.chreos.com
>>>
>>>Wild Software Ltd
>>>
>>>
>>>
>>>___________________________________________________________________________
>>>IB Objects - direct, complete, custom connectivity to Firebird or
>>>InterBase
>>> without the need for BDE, ODBC or any other layer.
>>>___________________________________________________________________________
>>>http://www.ibobjects.com - your IBO community resource for Tech Info
>>>papers,
>>>keyword-searchable FAQ, community code contributions and more !
>>>Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>___________________________________________________________________________
>>IB Objects - direct, complete, custom connectivity to Firebird or
>>InterBase
>> without the need for BDE, ODBC or any other layer.
>>___________________________________________________________________________
>>http://www.ibobjects.com - your IBO community resource for Tech Info
>>papers,
>>keyword-searchable FAQ, community code contributions and more !
>>Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>