> I have made this post before but did not get any response. Can
> someone at least tell me if this is normal. All help will be
> appreciated.
>
> I have a database (FB 1.5) with about 300 000 records in one
> table, I am using IBO for connectivity. The problem is that when I do
> a query (on the big table) whether there is data returned or not +/-
> 250 megs of ram gets used. The ram is only freed once I disconnect
> from the database.
>
> What can I do to make the memory usage less?
>
> Thanks
> William

do you limit the query by use of a WHERE clause at all? or are you just
pulling up all 300000 records?
Alan