On 11/22/2011 05:45 PM, Baruch Burstein wrote:
I will when I get the chance, but I am trying to get a list of things to
try to improve my SELECT speeds. If it is one SELECT, but returning +-1
rows, it probably won't make a difference, right?
No advantage in wrapping a single statement, of
On 22 Nov 2011, at 10:45am, Baruch Burstein wrote:
> I will when I get the chance, but I am trying to get a list of things to
> try to improve my SELECT speeds. If it is one SELECT, but returning +-1
> rows, it probably won't make a difference, right?
Right. It'll do a lock, then the
I will when I get the chance, but I am trying to get a list of things to
try to improve my SELECT speeds. If it is one SELECT, but returning +-1
rows, it probably won't make a difference, right?
On Tue, Nov 22, 2011 at 11:41 AM, Dan Kennedy wrote:
> On 11/22/2011
On 11/22/2011 04:34 PM, Baruch Burstein wrote:
Do transactions speed up SELECT statements?
They can a bit. If you put 10 SELECT statements in a transaction
SQLite only has to lock and unlock the database file once. If
you run them outside of a transaction the db is locked and unlocked
10
Do transactions speed up SELECT statements?
--
Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning. - Rich Cook
5 matches
Mail list logo