not all database allow create index "if not exists" this means web2py would have to keep track of what indices have been created and what no. This would introduce a new level of complexity and, in my view, would not really provide any benefit over creating indices manually.
Moreover every new feature we add to the existing DAL will delay the new DAL. Perhaps the new DAL will have this. Massimo On Sep 9, 9:12 pm, Richard <[email protected]> wrote: > yeah I know I can do it manually - that's what I ended up doing. > The reason given in the manual for lack of an API is it would "make > migrations complex". But this wouldn't be an issue in production where > migrate=False. > Or is there another reason? > > Richard > > On Sep 10, 11:53 am, mdipierro <[email protected]> wrote: > > > It does not support indices in the sense that it does not provide an > > API for indices. You can create indices with > > > db.executesql('CREATE INDEX ...;') > > db.commit() > > > You can do it from the shell. > > > Massimo > > > On Sep 9, 7:13 pm, Richard <[email protected]> wrote: > > > > According to the manual the DAL does not support indexes because it > > > would make migrations complex. > > > However we are recommended to use migrate=False in production. So > > > could the DAL somehow support indexes under this condition? > > > > Such a feature would have saved me some time - I had trouble with > > > database performance over the last few days and solved most of the > > > problems when I added an index to the main table. > > > > Richard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
