plinehan wrote:

>In firebird-support@yahoogroups.com,
>Adomas Urbanavicius <adomas@i...> wrote:
>
>
>
>
>>When we were to decide what component to use for our app,
>>zeos was in list, but it faced some problems while working
>>with quite large datasets
>>opened (~ 0.1 - 0.5 mil records ), i dont remember though
>>exactly what problems, but simple commands like
>>dataset->Last() , then First(), or lookup took far beyond
>>acceptable limits. ( It seems that IBOjects do
>>not suffer from this problem :) )
>>
>>
>
>
>That looks like TTable type syntax to me? I thought that
>good system design would dictate that one should never
>have 500.000 records open at once?
>

Well, lets say I see order transactions from date 2005.01.01 -
2005.02.01 (by default month back), it will be not much, but some
"clever" users will select dates
from 1970.01.01 till ....., and will definitely want that everything
worked fast :)
Adomas