Menu
▾
▴
Re: [WWdevel] relative speed of sql_single and gdbm
|
From: Arnold P. <ap...@ma...> - 2005-03-17 14:23:33
|
At 03:45 PM 3/16/2005, John Jones wrote: Hi John, I was being stupid. I forgot to restart the web server after changing the SQL.pm file. Doing that gives the times below. There seems to be a definite improvement using your new SQL.pm but not a dramatic one. When I did this there was a very light load on the server. Last semester using gdbm the vast majority of operations had runTime = 0.0 sec (and most operations are done during heavy use periods). Also Bill Wheeler reports that he switched to BerkeleyBD from gdbm because with his loads, gdbm was too slow (because writing locks applied to the whole database). I assume in his case, sql_single would be unusable as is. This is one area that needs a lot of optimization. Hopefully the current fix will be sufficient to provide a better experience for my 162 students. We'll see Sunday night when our next assignment is due. Arnie Thu Mar 17 09:00:28 2005] 38570 1111068028 - [/webwork2/mth162/7/6/] [runTime = 2.0 sec sql_single] [Thu Mar 17 09:00:35 2005] 38566 1111068035 - [/webwork2/mth162/7/6/] [runTime = 2.0 sec sql_single] [Thu Mar 17 09:00:39 2005] 38566 1111068039 - [/webwork2/mth162/7/6/] [runTime = 2.0 sec sql_single] [Thu Mar 17 09:00:43 2005] 38566 1111068043 - [/webwork2/mth162/7/6/] [runTime = 2.0 sec sql_single] [Thu Mar 17 09:00:46 2005] 38570 1111068046 - [/webwork2/mth162/7/6/] [runTime = 2.0 sec sql_single] [Thu Mar 17 09:00:49 2005] 38566 1111068049 - [/webwork2/mth162/7/6/] [runTime = 2.0 sec sql_single] [Thu Mar 17 09:03:02 2005] 38564 1111068182 - [/webwork2/mth162/instructor/progress/] [runTime = 1.0 sec sql_single] [Thu Mar 17 09:03:18 2005] 38565 1111068198 - [/webwork2/mth162/instructor/progress/set/7/] [runTime = 6.0 sec sql_single] [Thu Mar 17 09:05:11 2005] 38571 1111068311 - [/webwork2/mth162/] [runTime = 0.0 sec sql_single] [Thu Mar 17 09:05:13 2005] 38577 1111068313 - [/webwork2/mth162/7/] [runTime = 0.0 sec sql_single] [Thu Mar 17 09:05:14 2005] 38571 1111068314 - [/webwork2/mth162/7/1/] [runTime = 0.0 sec sql_single] [Thu Mar 17 09:05:20 2005] 38571 1111068320 - [/webwork2/mth162/7/1/] [runTime = 3.0 sec sql_single] [Thu Mar 17 09:05:24 2005] 38571 1111068324 - [/webwork2/mth162/7/1/] [runTime = 2.0 sec sql_single] [Thu Mar 17 09:05:27 2005] 38571 1111068327 - [/webwork2/mth162/7/1/] [runTime = 2.0 sec sql_single] [Thu Mar 17 09:05:31 2005] 38571 1111068331 - [/webwork2/mth162/7/1/] [runTime = 3.0 sec sql_single] [Thu Mar 17 09:05:34 2005] 38571 1111068334 - [/webwork2/mth162/7/1/] [runTime = 2.0 sec sql_single] >Arnold Pizer wrote: > >>At 02:57 PM 3/16/2005, John Jones wrote: >> >>I don't know if I can tell anything from the above or not. I seems >>submitting an answer does slow stuff down somewhat. How many BD calls are >>involved in that process? > >I don't know offhand. My basic approach to figuring this out is either >throw extra information in the timing log, or to write information to a >special log file. Including what webwork function in SQL is being called, >and the sql statement it uses should give an idea of how much and what >kind of activity is involved in a single submission. > >John > > >------------------------------------------------------- >SF email is sponsored by - The IT Product Guide >Read honest & candid reviews on hundreds of IT Products from real users. >Discover which products truly live up to the hype. Start reading now. >http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click >_______________________________________________ >OpenWeBWorK-Devel mailing list >Ope...@li... >https://lists.sourceforge.net/lists/listinfo/openwebwork-devel Prof. Arnold K. Pizer Dept. of Mathematics University of Rochester Rochester, NY 14627 (585) 275-7767 |
