[pysqlite] :memory: db
"Dinesh B Vadhia" <[email protected]> Thu, 3 Sep 2009 14:50:20 -0700
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============0276298576== Content-Type: multipart/alternative; boundary="----=_NextPart_000_0105_01CA2CA5.DBFA2430" This is a multi-part message in MIME format. ------=_NextPart_000_0105_01CA2CA5.DBFA2430 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable We want to store >5m rows in a :memory: sqlite db for read-only access. = Will we see a significant performance uptick against a disk-based sqlite = db? Could you provide pointers or links to optimizing :memory: db's for = read-only access. Thank-you! Dinesh ------=_NextPart_000_0105_01CA2CA5.DBFA2430 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.18812"></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>We want to store >5m rows = in a=20 :memory: sqlite db for read-only access. Will we see a significant = performance uptick against a disk-based sqlite db? Could you = provide=20 pointers or links to optimizing :memory: db's for read-only = access. =20 Thank-you!</FONT></DIV> <DIV><FONT color=3D#000080 face=3DGaramond></FONT> </DIV> <DIV><FONT color=3D#000080 = face=3DGaramond>Dinesh</FONT></DIV></BODY></HTML> ------=_NextPart_000_0105_01CA2CA5.DBFA2430-- --===============0276298576== 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 --===============0276298576==--