Server-side type-ahead data for Rev standalone

[Stephen Barncard]

It's not clear whether you're developing a thin client or a web app. 
The best features of Rev are clearly shown with the thin client of 
which I'd suggest for this.

I don't think mySQL used locally would be too slow and the network 
would be a bigger slowdown, but the kind of response you desire can 
really only accomplished in ram, which is where rev lives. I'd 
suggest a cache made from a list of keywords that were indexed in the 
database. This cache could be created when starting up and when a 
record is added and then loaded into a variable. You only have to get 
the list of the keywords from all the records in the database - so 
that's a lot less text than loading the whole records and should be 
fairly quick even on the net.

180000 records x 6 character key = 1080000 = 1 megabyte.

  The code for the "guessing" would be up to you but I'm sure it's not 
that hard. The selected item in the cache would be the key for a 
search of the rest of the record from the database and fill the 
fields. Lightning fast. Rev's built-in dictionary does this, as does 
Galaxy's message box.

By the way, mySQL is not a 'freebie'. And yes, Valentina will work 
fine as well.

sqb

>For instance, if I typed "Lib", I'd like Revolution to instantly provide the
>option of auto-completing the field with "Liberty School" (a type of wine).  
>If I type "Cha", it would provide auto-completion options including "Chataeu
>Coufran", etc.
>
>The trick is that there's a ton of records.   Would this auto-complete
>feature even be possible?   Are the freebie databases like mySQL on many ISP's
>really up to feeding-out data in real-time like that?   It would be 
>more like an
>AJAX-call instead of an HTML query with ?parm= data tacked on the end.
>

-- 


stephen barncard
s a n  f r a n c i s c o
- - -  - - - - - - - - -