How to use SQLite (sqlite3) more efficiently

[Demian Brecht]

> > 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20140604/4d3407e8/attachment.html>