Server-side type-ahead data for Rev standalone

[RGould8 at aol.com]

Stephen,

     Thanks for all your great advice!   This would be a Revolution 
standalone app (thin client) that pulls data from a system on the internet.   

     Now when you say that the response is best accomplished with the data in 
RAM   - - - do you suggest that I have the host server package up the 
keywords and pass it down to the thin-client as a 1 MB download upon startup, or is 
there a better way?   (RAM on the server, for quick response?)




In a message dated 1/5/07 1:52:17 PM, stephenREVOLUTION at barncard.com writes:


> 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
> - - -  - - - - - - - - -
> 
> 
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
>