Re: How to use SQLite (sqlite3) more efficiently

2014-06-09 Thread Philip Shaw
On 2014-06-06, Mark Lawrence wrote: > On 06/06/2014 22:58, Dave Angel wrote: >> Chris Angelico Wrote in message: >>> On Sat, Jun 7, 2014 at 4:15 AM, R Johnson >>> wrote: > The subject line isn't as important as a header, carried invisibly > through, that says that you were replying to an

Re: How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread Mark Lawrence
On 06/06/2014 22:58, Dave Angel wrote: Chris Angelico Wrote in message: On Sat, Jun 7, 2014 at 4:15 AM, R Johnson wrote: The subject line isn't as important as a header, carried invisibly through, that says that you were replying to an existing post. :) Sorry for my ignorance, but I've neve

Re: How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread Dave Angel
Chris Angelico Wrote in message: > On Sat, Jun 7, 2014 at 4:15 AM, R Johnson > wrote: >>> The subject line isn't as important as a header, carried invisibly >>> through, that says that you were replying to an existing post. :) >> >> Sorry for my ignorance, but I've never edited email headers befo

Re: How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread Chris Angelico
On Sat, Jun 7, 2014 at 4:15 AM, R Johnson wrote: >> The subject line isn't as important as a header, carried invisibly >> through, that says that you were replying to an existing post. :) > > Sorry for my ignorance, but I've never edited email headers before and > didn't find any relevant help on

Re: How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread Steve Hayes
On Thu, 5 Jun 2014 17:17:19 -0500 (CDT), Dave Angel wrote: >R Johnson Wrote in message: > >> >> I've attached some new sample code in which I've attempted to correct >> various things that you mentioned. > >Attachments don't work well for many people using this list. I > for one can't even s

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Chris Angelico
On Fri, Jun 6, 2014 at 8:57 AM, R Johnson wrote: > Sorry about that. As you can probably tell, I'm relatively new to using > mailing lists. I'm not exactly sure why that occurred like it did. I'll try > adding "Re:" in front of the subject when I send this e-mail, and see if it > works right this

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread R Johnson
Sorry for the attachment issue. I'm used to the wxPython-users Google group, where posters are instructed to attach code to their post instead of including it in the body of the message. I placed the latest version of my sample code below, since I made a few minor changes to it after posting it

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Chris Angelico
On Fri, Jun 6, 2014 at 6:12 AM, R Johnson wrote: > I forgot to mention that the scripts Peter pointed to used REPLACE instead > of INSERT OR REPLACE. The SQLite documentation says that REPLACE is an alias > for INSERT OR REPLACE provided for compatibility with other SQL database > engines. Is ther

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Chris Angelico
On Fri, Jun 6, 2014 at 3:42 AM, R Johnson wrote: > Thank you all for your replies and suggestions. > > To Chris's "two small points": > I saw that using the mailing list was recommended to several other people > who posted here using Google Groups, so I thought it might be recommended to > me as w

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Peter Otten
ps16thypresenceisfullnessof...@gmail.com wrote: > I'm completely new to SQL, and recently started using SQLite in one of my > Python programs. I've gotten what I wanted to work, but I'm not sure if > I'm doing it in the best/most efficient way. I have attached some sample > code and would apprecia

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Chris Angelico
On Thu, Jun 5, 2014 at 1:35 PM, Demian Brecht wrote: >> > 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 ha

Re: How to use SQLite (sqlite3) more efficiently

2014-06-04 Thread 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 f

Re: How to use SQLite (sqlite3) more efficiently

2014-06-04 Thread Rustom Mody
On Thursday, June 5, 2014 2:53:21 AM UTC+5:30, Chris Angelico wrote: > 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. : : > Happy to help out! But before I look into the code itself, two sma

Re: How to use SQLite (sqlite3) more efficiently

2014-06-04 Thread Chris Angelico
On Thu, Jun 5, 2014 at 6:27 AM, wrote: > I'm completely new to SQL, and recently started using SQLite in one of my > Python programs. I've gotten what I wanted to work, but I'm not sure if I'm > doing it in the best/most efficient way. I have attached some sample code and > would appreciate any