Mine is no secret: allcities.zip from geonames.org .
Well, I did not say mine was a secret. It is the same DB
Volunteers all around the world and allways growing.
Yes, always growing, always in need for an (easy, painless, smooth) update
I have got a StringGrid with > 70.000 rows and 19 columns.
Quick like hell. Colum sort in a second.
[QuickSort is Quick!!]
UTF8 search over 19 cols and 70.000 rows in less than a second.
So I don't need a DB
Just a quick question. How is filtering working for you ?
Think about it.
Oh, but I did
I do not blame you, but you seem to have only a single green pasture that you are looking at ?
Processing of the data for 25.000 entries alone takes about 40-50 seconds at my dark brown coloured pasture.
And.. the thing is slow as f*ck on certain widgetsets/hw. I won't even mention the quirks it has.
And before asking, I am aware of the components that are around in the world and I would like to avoid them. Even more so in case it is possible to solve it in another way, using standard components.
And that is besides the fact that I do not wish to display the data, rather only make it possible for the user to select from a filtered subset (if the user chooses to). So in that case the stringgrid would only serve as a storage space, which seems a bit counter-intuitive to me.
fwiw: I can understand your dislike about db usage.
Just 2 cents.