Hi all. I have a db v.3.0.1 of 32Mb with a single table and 598356 rows (no indexes). Doing a insert xx into select ... using no joins, only sums and groups by, it takes hours to complete. Besides RAM comsumption raises up to 500MB or more till I ran out of virtual memory. Rows are small in size.
I guess to do a group by one would have to sort rows and sorting is using RAM. Could this explain it? I've change vdbeaux.c line 773 to not use the sqlite3BtreeFactory (db ":memory:",...) but it didnd't help. I'm a bit concerned about the high memory consumption using "group by" (and posibly other statements). I have the db (zipped is "only" 15MB) and a script to run with the .read metacommand if anyone is interested. By the way, the same happens with 2.x versions. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
