[sqlite] Re: Optimising Large Tables by Splitting 1:1

2006-03-10 Thread James Austin
The question is more to do with theoretical optimisation rather than improving the speed of that specific database (which was used only for benchmarks), also note that the 700 record difference was based on around 5000 queries per second (definitly not a margin of error (this is a problem with

[sqlite] Re: Optimising Large Tables by Splitting 1:1

2006-03-10 Thread James Austin
The question is more to do with theoretical optimisation rather than improving the speed of that specific database (which was used only for benchmarks), also note that the 700 record difference was based on around 5000 queries per second (definitly not a margin of error (this is a problem with

[sqlite] Re: Optimising Large Tables by Splitting 1:1

2006-03-10 Thread James Austin
The question is more to do with theoretical optimisation rather than improving the speed of that specific database (which was used only for benchmarks), also note that the 700 record difference was based on around 5000 queries per second (definitly not a margin of error (this is a problem with

[sqlite] Re: Optimising Large Tables by Splitting 1:1

2006-03-10 Thread James Austin
The question is more to do with theoretical optimisation rather than improving the speed of that specific database (which was used only for benchmarks), also note that the 700 record difference was based on around 5000 queries per second (definitly not a margin of error (this is a problem with