-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Op 17-05-10 16:51, Matthew Jones schreef:
Another huge issue is that deleting records from a table still won't shrink the size of the table. I like to keep some of my raw data tables small so once a day I delete some already processed records out of them, dump the table, and then reload it.
Another quicky would be: start transaction; drop table activeselecting; create table activeselecting... insert into activeselecting select * from alldata; commit; Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.15 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAkvxWWsACgkQYH1+F2Rqwn1x7ACfUg0LWJsef3ONbxtw9b9NO7RD Qs0An3EM/jy4E5SftTE+9tvEqnQ0ryMV =629O -----END PGP SIGNATURE-----