Server-side type-ahead data for Rev standalone
RGould8 at aol.com
RGould8 at aol.com
Fri Jan 5 14:36:43 EST 2007
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
>
>
More information about the use-livecode
mailing list