Hi,
I just spent the day adding a 30GB swap area (!) to my machine so I
could query my server with TSQLServer without crashing. Unfortunately,
I just crashed again with an out-of-memory error.
Per Fons, the code collects the data in RAM and swap and then you use
TSQLRow (I think that's the class) to get row by row. A db connection
in MySQL would looks like:
mysql -h myhostname -u myusername -p
If I put a "-q" in front of the "-h", then the db would give me
row-by-row as it found them instead of building up the huge (HUGE!)
buffer first and giving me the rows second. Unfortunately, in root you
are stuck with
TSQLServer("myhostname", "myusername", "mypassword")
...with no place for the -q option and no code in the class to do
anything with it. May I please request the author revisit the
TSQLServer class to perhaps allow "-q" or some form of block transfers
...I am stuffing swap to the bursting...and beyond.
(Although in MySQL it is possible to "limit 100000" or something to get
the first N events, it is not to my knowledge possible to skip those
same events when you come back for the remainder. So I don't really
have much of a way around this.)
- John
This archive was generated by hypermail 2b29 : Thu Jan 01 2004 - 17:50:13 MET