Creating a Search Field

[Andre.Bisseret]

Le 29 avr. 08 à 19:37, william humphrey a écrit :
> How many lines of data in the big field?  I don't have much data in my
> SQLite database (about 2000 lines of data in some tables and about ten
> tables). How come you are not using a database? It is so much fun  
> deciding
> between SQLite or Valentina and then learning all that SQL stuff...

>
> ______________________________________________

Actually, in the app. I have developed, not a lot of lines ; currently  
I think the max is in the app. I maid for a friend of mine who is a  
physician; a couple of months ago it was about 500 lines, could be  
600. So there is practically no waiting time.
Up to now I don't need to use databases ; stacks are my datebases ;-)  
but I know I have to learn about this stuff (among a lot of others ;-)))

Well, I just tried with 5500 lines in the field "bigField" (each is as  
follow : one word,one number)
Actually, it is the list of the different words I found since I began  
to play "JQ Boogle", ;-)))
(It is the game developed by Jacque Landman Gay (that she offers on  
her site).

Each line includes a word and the number of times it was found (ex :  
TEA,286 - FILTERED,1 ;-).

The searching time I found when typing a first char is in seconds (the  
max was between 4 and 5 sec. for the letters T and S for example)
After, for the second character, sometimes about 1 sec, most often  
several hundred milliseconds
And from the third character to the last, insignifiant.

Best regards from Grenoble

André