On Tuesday 25 November 2003 18:42, shane hill wrote: > > Our db is getting to be a respectable size (about 10GB right now) and is > growing slower and slower. I have been charged with making it faster and > with a smaller footprint while retaining all of the current > functionality. here is one of my ideas. Please tell me if I am crazy:
Your idea of using an integer makes sense - that's how it is stored on unix anyway. Are you familiar with VACUUM/VACUUM FULL/REINDEX and when you should use them? If not, that's a good place to start. Try a VACUUM FULL on frequently updated tables and see if that reduces your disk size. You'll probably want to check the performance notes too: http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly