Hello,
I create the table from CL like this:
tsql "create table LUMthreads (forumid counter, threadlink varchar(250), useragent varchar(250), superproxy varchar(200), proxysession varchar(15), lastfetch date)"
then I access it from Vortex script. Currently the table has around 1200 records, so it's not that big.
When I try this SQL query:
<sql "select distinct forumid, useragent, superproxy, proxysession from LUMthreads where lastfetch < $timelimit order by lastfetch">
<$counts=($counts+1)>
</sql>
it returns series of errors like this:
<!-- 011 testkeepalive:10: Cannot insert 3632-byte value `...W....0...................Mo.............1535021033464.......' into B-tree (temp RAM DBF): Value too large in the function btinsert -->
apparently the "distinct" clause and grouping as many as 4 fields, is what cases some internal processes to exceed their limits. Without "distinct" the query works fine. Also if I group only by one field, like this:
<sql "select distinct forumid from LUMthreads
where lastfetch < $timelimit order by lastfetch">
I still get series of errors but different ones:
<!-- 100 testkeepalive:10: Could not find field lastfetch in the function Evaluate -->
My question is - is there some way I can setup the table so it can handle the above query?
thanks!
Nenad
I create the table from CL like this:
tsql "create table LUMthreads (forumid counter, threadlink varchar(250), useragent varchar(250), superproxy varchar(200), proxysession varchar(15), lastfetch date)"
then I access it from Vortex script. Currently the table has around 1200 records, so it's not that big.
When I try this SQL query:
<sql "select distinct forumid, useragent, superproxy, proxysession from LUMthreads where lastfetch < $timelimit order by lastfetch">
<$counts=($counts+1)>
</sql>
it returns series of errors like this:
<!-- 011 testkeepalive:10: Cannot insert 3632-byte value `...W....0...................Mo.............1535021033464.......' into B-tree (temp RAM DBF): Value too large in the function btinsert -->
apparently the "distinct" clause and grouping as many as 4 fields, is what cases some internal processes to exceed their limits. Without "distinct" the query works fine. Also if I group only by one field, like this:
<sql "select distinct forumid from LUMthreads
where lastfetch < $timelimit order by lastfetch">
I still get series of errors but different ones:
<!-- 100 testkeepalive:10: Could not find field lastfetch in the function Evaluate -->
My question is - is there some way I can setup the table so it can handle the above query?
thanks!
Nenad