By the way, here is the log from my test harness for an "Update" cycle
(which changes a single column in a 46 column table and then undoes that
change).
The relevant lines are those marked "<<======== Connection.Edit"
Bruce
================================> Using repo gb.db.postgresql Main.c
Test.TestUpdate.188: 1) Load object
Persistor.ReadDB.337: Query : MyObject.Mtgcode = MORN110424 AND
MyObject.Hname = The Tiger
GB .Exec (0.0173 secs)
Load Succeeded for The Tiger/MORN110424 (0.0177 secs)
Comment="{-}"
Test.TestUpdate.197: 2) Saved changed object
GB .Begin (0.0008 secs)
GB .Edit (0.5042 secs) <<======== Connection.Edit
GB .Update (0.007 secs)
GB .Commit (0.0186 secs)
Persistor.ReadDB.337: Query : MyObject.Mtgcode = MORN110424 AND
MyObject.Hname = The Tiger
GB .Exec (0.0165 secs)
Save Succeeded for The Tiger/MORN110424 (0.548 secs)
Comment (changed)="Test Update"
Test.TestUpdate.211: 3) Reload object
Persistor.ReadDB.337: Query : MyObject.Mtgcode = MORN110424 AND
MyObject.Hname = The Tiger
GB .Exec (0.0044 secs)
Load Succeeded for The Tiger/MORN110424 (0.0047 secs)
Comment="Test Update"
Test.TestUpdate.219: 4) Reset to original value
GB .Begin (0.0007 secs)
GB .Edit (0.4917 secs) <<======== Connection.Edit
GB .Update (0.0045 secs)
GB .Commit (0.0177 secs)
Persistor.ReadDB.337: Query : MyObject.Mtgcode = MORN110424 AND
MyObject.Hname = The Tiger
GB .Exec (0.0168 secs)
Save Succeeded for The Tiger/MORN110424 (0.5322 secs)
Comment="{-}"
================================> Using modified Main.c
Test.TestUpdate.188: 1) Load object
Persistor.ReadDB.337: Query : MyObject.Mtgcode = MORN110424 AND
MyObject.Hname = The Tiger
GB .Exec (0.0172 secs)
Load Succeeded for The Tiger/MORN110424 (0.0176 secs)
Comment="{-}"
Test.TestUpdate.197: 2) Save changed object
GB .Begin (0.0007 secs)
GB .Edit (0.0705 secs) <<======== Connection.Edit
GB .Update (0.0069 secs)
GB .Commit (0.0493 secs)
Persistor.ReadDB.337: Query : MyObject.Mtgcode = MORN110424 AND
MyObject.Hname = The Tiger
GB .Exec (0.0213 secs)
Save Succeeded for The Tiger/MORN110424 (0.1496 secs)
Comment (changed)="Test Update"
Test.TestUpdate.211: 3) Reload object
Persistor.ReadDB.337: Query : MyObject.Mtgcode = MORN110424 AND
MyObject.Hname = The Tiger
GB .Exec (0.0043 secs)
Load Succeeded for The Tiger/MORN110424 (0.0047 secs)
Comment="Test Update"
Test.TestUpdate.219: 4) Reset to original value
GB .Begin (0.0008 secs)
GB .Edit (0.0715 secs) <<======== Connection.Edit
GB .Update (0.0046 secs)
GB .Commit (0.0234 secs)
Persistor.ReadDB.337: Query : MyObject.Mtgcode = MORN110424 AND
MyObject.Hname = The Tiger
GB .Exec (0.0166 secs)
Save Succeeded for The Tiger/MORN110424 (0.1179 secs)
Comment="{-}"
------------------------------------------------------------------------------
Systems Optimization Self Assessment
Improve efficiency and utilization of IT resources. Drive out cost and
improve service delivery. Take 5 minutes to use this Systems Optimization
Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
