Re: [sqlite] Slow performance - Unrealistic expectations?

[Alex Chudnovsky]

Thom Ericson wrote:

I had hoped to be able to handle 180,000,000 rows in my largest 
installation (that's gonna take a
while).  Any hints from anyone????

IMHO 180 mln rows is no small deal even for a big database - especially 
considering you have got text column in it.

If you are trying to implement something like full-text search, then you 
are better off creating your own highly tuned for your purposes custom 
database.

Alex