Memory Allocation Error

Post Reply
gazim
Posts: 66
Joined: Sun Feb 18, 2001 1:01 pm

Memory Allocation Error

Post by gazim »

I am getting the following error when I query the index with a % operator.

Error:
Cannot alloc 1256276 bytes of memory: Cannot allocate memory in the function fdbix_readbuf

my query: tsql "set indexaccess=1;select count(Word) from idx_myindex where Word like '%90luncheon'";

There are 25000 hits if I search for the exact word luncheon against the table.

My table's cardinality is 12806035

and the sizes of idx_myindex files:
27G - idx_myindex.dat
4.5G - idx_myindex.btr
98M - idx_myindex.tok

Thank you in advance!
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Memory Allocation Error

Post by John »

It may be reading most of the 4.5G - idx_myindex.btr file into memory to try and answer that query. You might try something in Vortex like:

<$count=0>
<sql "set indexaccess=1"></sql>
<sql ROW "select Word from idx_myindex">
<if $Word like '%90 luncheon'>
<$count=(1+$count)>
</if>
</sql>

or if you want to do a bunch of queries in tsql you could do:

set indexaccess=1;
create table wordlist as select * from idx_myindex;
select count(*) from idx_myindex where Word like '%90 luncheon';
John Turnbull
Thunderstone Software
Post Reply