>
>
> I don't actually need it to make the changes, so don't do it if it is too
> much work. It would just make it easier for me to run some of my own tests.
>
>
Well, here is something you can try, assuming you still have the database
generator I put together some time ago. It runs out of memory in my 32-bit
environment with a db consisting of 20,000 rows and 149 columns. I don't
know what to recommend if it runs OK in your environment ...
Staffan
a=.a~new
::class a
::method init
expose count
conn=.oosqliteconnection~new("large.db")
conn~progressHandler(self,1)
count=0
sql="SELECT * FROM (SELECT * FROM (SELECT * FROM TBL1 WHERE COL1 IN (SELECT
COL1 FROM TBL1 WHERE COL2 LIKE 'R%' AND COL3 LIKE 'R%' AND COL4<>'ROW_1'
AND COL5>'ROW' AND COL6<'XXX' AND COL7 LIKE 'R%' AND COL8 LIKE 'R%' AND
COL32<>'YYY' AND COL41 LIKE 'R%' GROUP BY COL22)) WHERE COL10<>'XXX') LEFT
OUTER JOIN TBL1 AS Q1 CROSS JOIN TBL1 AS R4 WHERE R4.COL11 NOT NULL GROUP
BY Q1.COL1,Q1.COL2,R4.COL3,Q1.COL4,Q1.COL5 LIMIT 100;"
conn~exec(sql)
say conn~lasterrmsg
say "Count:" count
::method progressCallBack
expose count
count+=1
return 0
::requires "oosqlite.cls"
------------------------------------------------------------------------------
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d
_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users
