We're receiving some reports from different customers that they're receiving
Out of Memory errors when running our software. We've tracked it down to
appearing like it's related to a table having 200 or 250k records in it.
The table in question has quite a few fields and indexes, so each record is
large. I would say something like "Bad data in the table" but it's
happening in multiple sites, and the data looks clean from the sites we've
gotten it from.
What's more, IBConsole is also getting this error when looking at the data
tab in a table's properties (Originally, the tech guys thought it had
something to do with the BDE, which our application uses (Yes, boo hiss) to
connect to IB.. Then I pointed out that IBConsole doesn't use the BDE and it
was also having this issue, and they said "Oh"). I've seen posts across the
internet saying "Umm.. Yeah.. That happens, don't make huge scrollable
datasets.". I'm wondering if the gurus here know anything more, since the
architecture of this version of our program relies on scrollable table type
access and rewriting it isn't an option. Is increasing page buffers/size
any sort of viable solution to this?
Switching to IBO (Since that's a popular answer to most any problem that's
not strictly SQL) is a possibility, if I can prove that it's solved this
sort of thing before. IE we don't want to take the time to write another
compatiblity layer using the IBO components unless we know, or have a strong
suspicion, that it will fix the problem. But, given that the problem
happens using both BDE and IBX components, I have my doubts about IBO fixing
the problem.
Any help is greatly appreciated.

- Jason