Re: [sqlite] Performace degradation over time

2005-05-29 Thread John Ruttenberg
Allan Wind: > On 2005-05-29T11:51:27-0400, John Ruttenberg wrote: > Content-Description: message body text > > I have a benchmark program that demonstrates significant performace > > degradation over time. Here is what this benchmark does: > > > > 1. Create a ta

[sqlite] Performace degradation over time

2005-05-29 Thread John Ruttenberg
I have a benchmark program that demonstrates significant performace degradation over time. Here is what this benchmark does: 1. Create a table with a primary integer key and a blob value. 2. Populate the table with 1M rows. In all cases the blobs are strings with random lengths be