Oh fair enough. How far along is the new DAL?
Richard On Sep 10, 12:19 pm, mdipierro <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
