Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #72674

Re: How to use SQLite (sqlite3) more efficiently

Show all headers | View raw

[Multipart message — attachments visible in raw view] - view raw

> > On Thu, Jun 5, 2014 at 6:27 AM, ps16thypresence wrote:
>
> > > I'm completely new to SQL, and recently started using SQLite in
> > > one of my Python programs.

Unrelated to Python but as you're new to SQL I figured I'd ask: Do you have
an index on the name field? If you don't, you'll incur a full table scan
which will be more expensive than if you have an index in the field.

For more info about indexes see http://www.sqlite.org/lang_createindex.html.

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

How to use SQLite (sqlite3) more efficiently ps16thypresenceisfullnessofjoy@gmail.com - 2014-06-04 13:27 -0700
  Re: How to use SQLite (sqlite3) more efficiently Chris Angelico <rosuav@gmail.com> - 2014-06-05 07:23 +1000
    Re: How to use SQLite (sqlite3) more efficiently Rustom Mody <rustompmody@gmail.com> - 2014-06-04 19:15 -0700
      Re: How to use SQLite (sqlite3) more efficiently Demian Brecht <demianbrecht@gmail.com> - 2014-06-04 20:35 -0700
      Re: How to use SQLite (sqlite3) more efficiently Chris Angelico <rosuav@gmail.com> - 2014-06-05 17:08 +1000
  Re: How to use SQLite (sqlite3) more efficiently Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2014-06-04 22:40 -0400
  Re: How to use SQLite (sqlite3) more efficiently Peter Otten <__peter__@web.de> - 2014-06-05 09:48 +0200

csiph-web