Menu
▾
▴
Re: [WWdevel] relative speed of sql_single and gdbm
|
From: John J. <jj...@as...> - 2005-03-17 15:47:07
|
Arnold Pizer wrote: > 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. What about timing with old SQL.pm with binary removed? If you might have a case conflict (database keys which differ only in case), then I wouldn't try it until after the semester is over. It would tell us if there are gains to be had by making further changes to SQL.pm. John > 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 > > > > ------------------------------------------------------- > 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 |
