You can keep and eye on what SQLObject is doing behind your back by
setting myObject._connection.debug= True, I added support for
monitoring this from within CatWalk, check http://
www.checkandshare.com/blog/?p=21 for the details.
Cheers,
Ronald
On Nov 2, 2005, at 4:17 PM, Kevin Dangoor wrote:
On 11/1/05, modmans2ndcoming <[EMAIL PROTECTED]> wrote:
I am new to DB dev work, and I was just curious about Lazy updates.
It seems that a lot of people are concerned about the number to
updates
that are generated using SQLObject.
I'm not sure about *a lot* of people... but there are certainly some.
Lazy updates allow you to not update the db every time you make a
change? Why is that important? How often do you change data after you
update it?
Here's an example:
foo.bar = "Hello"
results in some SQL like:
UPDATE Foo SET bar = 'Hello' where id=5
That gets sent on to your database server.
Some people are concerned about the amount of traffic to the database
server if you end up not committing those changes.
Kevin
________________________________
Ronald Jaramillo
mail: ronald AT checkandshare DOT com
blog: http://www.checkandshare.com/blog
