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 -~----------~----~----~----~------~----~------~--~---
