[Gambas-user] Hopefully, an optimisation for gb.db.postgresql

[Bruce Bruen]

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="{-}"