-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ludvig Strigeus wrote: > I would like to have a single table larger than 2GB...though.
FAT16 has a maximum file size of 2GB. FAT32 (the most common one in use today) has a maximum file size of 4GB. It is impossible to have single files larger than those sizes. See http://en.wikipedia.org/wiki/File_Allocation_Table SQLite does not support splitting the database across multiple files behind the scenes. (Other database implementations such as Postgres can, but they aren't 'lite'). You can partition your table across multiple databases, each less than 2GB but all of your SQL code will have to be aware of that. An alternative is to use virtual tables which will let you present the impression of a single table, while accessing the partitioned table behind the scenes. http://www.sqlite.org/cvstrac/wiki?p=VirtualTables Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGIFqjmOOfHg372QQRApLSAJ4kanFb0aEaXSdzV+UXG/2PNFIWmQCeO3O1 dqatDP3qYpoU4QRne554f4w= =jJdQ -----END PGP SIGNATURE----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
