I'm still using sqlite and I'm hoping that it will do. I'll note the advice for the connection pooling should I move off of sqlite.
My question was whether there was a parameter/attribute that I could set in the request object to use to select which tables I declare for a particular request. I haven't timed this all yet but my app is slowing down and I'm wondering if declaring all these tables is slowing things down. Does the model files know of the request object? If I set an attribute in the request object can I test for this in the model code? (Yes, it may be that this is not where the slowdown is - I haven't tested it yet) At a shop that I used to work we kept things segmented into different apps and it was a nightmare - both for the difficulty in communicating between apps and for performance. I would not do that. It may well be that the slow down is caused by all the xmlrpc calls being made. I may be able to improve performance if I consolidate the functionality into fewer calls. I'm a firm believer in not optimizing code (early), so I'd rather not muck things up this way. It is true that the nature of the program is that it is fairly segmented in its table usage. Oh, I am not currently using migrate=true. Perhaps... As always, many thanks for the advice and other comments. You all are a great support to have. -- Rb On Sep 29, 8:47 am, mdipierro <[email protected]> wrote: > Because model are re-read at every request, modules are not. > I am not sure if this is a big effect since the code has to be > executed anyway. Just worth a try. > > @rb, one more thing. Make sure you use connection pooling if you do > not use sqlite. > > On Sep 29, 9:55 am, Jonathan Lundell <[email protected]> wrote: > > > On Sep 29, 2009, at 7:03 AM, mdipierro wrote: > > > > If you still need more speed move the table definitions in a module > > > (not a model) and import it from the model. I would not recommend this > > > to everybody but 93 is a lot. > > > How does that speed things up? (Just curious.) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
