[pysqlite] :memory db
"Dinesh B Vadhia" <[email protected]> Wed, 1 Jul 2009 19:38:04 -0700
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============1980001913== Content-Type: multipart/alternative; boundary="----=_NextPart_000_0055_01C9FA83.739C6960" This is a multi-part message in MIME format. ------=_NextPart_000_0055_01C9FA83.739C6960 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Is there a good source on how to create an in-memory pysqlite db? = Specifically, do you create a new :memory db and load the data into the = db or can you load an existing sqlite db into memory?=20 Our db schema is simple but the db contains > 4m records and will be run = on a 64-bit OS with 6 to 8gb of available ram. The reason for wanting = to use a :memory db is purely performance. Cheers! Dinesh ------=_NextPart_000_0055_01C9FA83.739C6960 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3Dtext/html;charset=3DWindows-1252 = http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18783"></HEAD> <BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: = 15px"=20 id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 = CanvasTabStop=3D"true"=20 name=3D"Compose message area"> <DIV><FONT color=3D#000080 face=3DGaramond>Is there a good source on how = to create=20 an in-memory pysqlite db? Specifically, do you create a new = :memory db and=20 load the data into the db or can you load an existing sqlite db into=20 memory? </FONT></DIV> <DIV><FONT color=3D#000080 face=3DGaramond></FONT> </DIV> <DIV><FONT color=3D#000080 face=3DGaramond>Our db schema is simple but = the db=20 contains > 4m records and will be run on a 64-bit OS with 6 to 8gb of = available ram. The reason for wanting to use a :memory db is = purely=20 performance.</FONT></DIV> <DIV><FONT color=3D#000080 face=3DGaramond></FONT> </DIV> <DIV><FONT color=3D#000080 face=3DGaramond>Cheers!</FONT></DIV> <DIV><FONT color=3D#000080 face=3DGaramond></FONT> </DIV> <DIV><FONT color=3D#000080 face=3DGaramond>Dinesh</FONT></DIV> <DIV><FONT color=3D#000080 = face=3DGaramond></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0055_01C9FA83.739C6960-- --===============1980001913== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ list-pysqlite mailing list list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite --===============1980001913==--