| OCR Text |
Show 77 5.5.1.7 ObServer: Ol)erat ions vs. s ize of object lu tl 1is test, the elapsed t ime for difl"creut operat ions (create, load, and update) with varying object s ize in ObServer a re compared. T he comparison is done in both local and remote settings as shown in Figure 5.20. As before, create takes the maximum amouiJt of t ime. One s urpris ing result is t hat load takes longer t han update. One expla nation could be t hat a ll updates a re preceded hy loading the o bjf~cts in . In t he p resent t est , the size of the o bj ect is being increased. As a result, cachi ng of t he object on t he ser ver clue to the load done in the same session s t a rts affecting t he res ul t . 5.5 .1. 8 ESM: operat ions vs. s ize of object In t l1 is test , the t-' lapsed t ime for cl iHen"'nt operatio ns (c reate, load , and update) with vary ing o bject size in CSNI arC' com pared. The compa ri son is done in hoth lou:tl and remote set tings as can be seen in F igure 5.21. ll pda.te t inws become worse in the case of la rge object s. This is because of storing la rge logging reco rd s. The s it uation becomes worse in the distribu ted case <l S these records have to be s hipped from th e c lient loggin g subsystem to t he server. 5.5 .1.9 Postgres: op erations vs . size of object In t his tesL , Ll1e e lapsed t ime for different ope rations (creat e, load , a nd update) with vary ing object s ize in Postgres a re com pared . T he compa ri son is done in both loccd and remote settings as shown in Figure 5.22. 5.5. 1.10 U pdates ch a n gi ng object size .Aiphd._l use~ va.ri a ble s ized arrays and cha racter strings as datatyp es . This can l<'<ld 1o a cll ange i11 ohjccL s ize. This test was do ne to find out l1ow diffe re nt POSs hebavl-' when the object s ize changes 011 update. |
