When you have SELECT * FROM table WHERE condition, the condition is always local, i.e. it is applied to each individual record. The check one record is independent on the check on other records. Therefore I believe LIKE, OR, IN, etc should scale on GAE as well as AND,=,<,>. I hope we will see them soon.
On Oct 15, 10:08 am, Timothy Farrell <[EMAIL PROTECTED]> wrote: > Keep in mind that selecting based on like can be a resource-intensive > process for large tables (you have to examine every record rather than > look at an index). They probably left it out until they saw what kind > of load they would be dealing with on GAE. Plus, Google uses a > distributed file system. It could be the case that a simple "like" > query could request multiple files from multiple computers. That > scenario would be a bottleneck nightmare. > > Just thinking > -tim > > mdipierro wrote: > > I cannot believe it either. I am not spending time coding a workaround > > because I expect them to fix it. > > > On Oct 15, 4:02 am, "Steve Shepherd" <[EMAIL PROTECTED]> wrote: > > >> Massimo > >> Talking about GAE is there any work around for the LIKE command when > >> searching for records. > >> I can't believe a search company like google has not got a fantastic method > >> of searching their object repository. > > >> Steve > > >> On Wed, Oct 15, 2008 at 4:43 AM, mdipierro <[EMAIL PROTECTED]> wrote: > > >>> On the web2py today, if you get the windows or mac binaries you get > >>> version 1.45. > >>> If you get the source you get version 1.46. What is the difference? > > >>> They are the same but for the scaffolding "welcome" app. In 1.46 its > >>> should work out of the box on GAE. > > >>> Eventually I will update the binaries to but there is no real need > >>> since you cannot use them on GAE. > > >>> Anyway, give it a try to make sure I did not do obvious mistakes. > > >>> Massimo > > > > tfarrell.vcf > < 1KViewDownload --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
