Hi, I have just started using webware and middlekit, and am essentially experimenting and seeing whether I should convert an in development site to use it instead of my home grown middleware. So I have a couple of questions about how to use it.
1. To execute sql queries that don't fall into the object schema I am currently doing conn,curs=store.executeSQL(sql) res=curs.fetchall() Is this the recommended way?? 2. Should I have global access to 'store', or should each module where it is used create it's own store?? I noticed in the source for SQLObjectStore, that new connections are created all over the place anyway. So would this be much of a performance hit? how does everyone else do this?? 3. In the experimental project that I am playing around with, it requires initially about 1.5m transactions on the database to set up the data. For some reason that I am not clear on the app starts to really slow down about halfway into this, it looks like it is having trouble with the amount of memory it is using, because it really starts to flail away at the disk cache. I tried doing store.clear() to make sure that it wasn't storing to many objects locally, but that didn't help at all. I also thought it might be a problem with the number of connections that it was creating and discarding. Thanks for your help. Jonathan ------------------------------------------------------- This sf.net email is sponsored by: Dice - The leading online job board for high-tech professionals. Search and apply for tech jobs today! http://seeker.dice.com/seeker.epl?rel_code=31 _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
