I will never use SQLObject again, and will try and port all my existing SQLObject code in to SA. It's just too slow and inefficient, working with large datasets becomes unusable. Currently I have code which selects 350,000 or so items from a 2,000,000 or so set and performs an operation on each of them. Even when using SelectResults it is stupendously slow because SO will *always* make >n+1 queries when n rows are returned. I can perform the same operation with the MySQLdb driver in literally a tiny fraction of the time.
Sad really.. the SO ORM really opened my eyes to MVC, I hope I can be bothered to maintain the methodology in the future. Maybe by then ActiveMapper will be usable. -Rob [EMAIL PROTECTED] wrote: > I was thinking that BDB could be made into a SQL database with code. > It was not very fast for me though when I tried to use it. SQLite is > simpler and can be faster than other dbs at first I guess. I looked > at sqlalchemy and it looks like it could make sqlobject like frameworks > fast. I have some code that looks at foreign keys and gets their value > in SQLObject I do not know how to look them up without a separate > cursor in mysqldb. That is why sqlalchemy is looking good over > sqlobject to me right now. I guess I won't be able to use BDB then dang. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears -~----------~----~----~----~------~----~------~--~---
