Quote:
Originally posted by mickallen
Do you have any problems with this in terms of speed or searching?
|
I do! But it depends on how "speed of searching" is defined. Is it the the time that UR returns the results , or the time you actually find what you're looking for?
The former is only slightly dependent on the size of db, but if you reach some very high numbers (maybe 20000, 30000 ... see sqlite documentation) it will slow considerably.
If it is the latter, the one I'm concerned about, the time until you find sth that you look for will be approximately linearly dependent on the size of actual db.
This is not enough!!!
For the discussion of this point, see
relevance search