Menu
▾
▴
Re: [WWdevel] relative speed of sql_single and gdbm
|
From: Arnold P. <ap...@ma...> - 2005-03-21 12:45:46
|
At 11:30 AM 3/17/2005, Arnold Pizer wrote: The small test I did showing a dramatic speed up with John's fix of removing "binary" seems to be born out by last night results. Here's a small snippet. Most times seem to be 0 or 1 second which is what we saw last semester with gdbm. [Sun Mar 20 21:49:41 2005] 38879 1111373381 - [/webwork2/mth162/8/8/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:47 2005] 39785 1111373387 - [/webwork2/mth162/8/5/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:48 2005] 39166 1111373388 - [/webwork2/mth162/8/1/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:49 2005] 39501 1111373389 - [/webwork2/mth165/9/4/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:50 2005] 40245 1111373390 - [/webwork2/mth162/8/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:51 2005] 40559 1111373391 - [/webwork2/mth162/8/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:52 2005] 40245 1111373392 - [/webwork2/mth162/8/9/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:54 2005] 40961 1111373394 - [/webwork2/mth162/8/9/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:57 2005] 38171 1111373397 - [/webwork2/mth161/7/12/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:49:58 2005] 38879 1111373398 - [/webwork2/mth162/8/10/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:00 2005] 38171 1111373400 - [/webwork2/mth161/logout/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:01 2005] 41128 1111373401 - [/webwork2/mth162/8/10/] [runTime = 1.0 sec sql_single] [Sun Mar 20 21:50:01 2005] 39785 1111373401 - [/webwork2/mth162/8/8/] [runTime = 1.0 sec sql_single] [Sun Mar 20 21:50:05 2005] 38590 1111373405 - [/webwork2/mth162/8/5/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:07 2005] 39178 1111373407 - [/webwork2/mth162/8/3/] [runTime = 1.0 sec sql_single] [Sun Mar 20 21:50:08 2005] 39871 1111373408 - [/webwork2/mth162/8/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:09 2005] 39945 1111373409 - [/webwork2/mth162/8/9/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:10 2005] 39871 1111373410 - [/webwork2/mth162/8/10/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:13 2005] 40559 1111373413 - [/webwork2/mth162/8/6/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:13 2005] 39871 1111373413 - [/webwork2/mth162/8/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:14 2005] 41038 1111373414 - [/webwork2/mth162/8/7/] [runTime = 1.0 sec sql_single] [Sun Mar 20 21:50:14 2005] 38171 1111373414 - [/webwork2/mth162/8/6/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:15 2005] 41038 1111373415 - [/webwork2/mth162/8/8/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:15 2005] 41129 1111373415 - [/webwork2/mth162/8/10/] [runTime = 1.0 sec sql_single] [Sun Mar 20 21:50:16 2005] 40961 1111373416 - [/webwork2/mth162/8/5/] [runTime = 1.0 sec sql_single] [Sun Mar 20 21:50:16 2005] 39166 1111373416 - [/webwork2/mth162/8/5/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:18 2005] 40559 1111373418 - [/webwork2/mth162/8/6/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:18 2005] 39785 1111373418 - [/webwork2/mth162/8/6/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:20 2005] 41038 1111373420 - [/webwork2/mth162/8/9/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:20 2005] 39785 1111373420 - [/webwork2/mth165/9/1/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:21 2005] 40559 1111373421 - [/webwork2/mth162/8/7/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:21 2005] 39501 1111373421 - [/webwork2/mth162/8/9/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:22 2005] 39945 1111373422 - [/webwork2/mth165/logout/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:22 2005] 39501 1111373422 - [/webwork2/mth162/8/10/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:22 2005] 40559 1111373422 - [/webwork2/mth162/8/8/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:24 2005] 38171 1111373424 - [/webwork2/mth162/8/6/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:24 2005] 40559 1111373424 - [/webwork2/mth162/8/9/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:25 2005] 39785 1111373425 - [/webwork2/mth165/9/1/] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:27 2005] 41128 1111373427 - [/webwork2/mth162] [runTime = 0.0 sec sql_single] [Sun Mar 20 21:50:27 2005] 38879 1111373427 - [/webwork2/mth162/8/2/] [runTime = 0.0 sec sql_single] Arnie >At 10:47 AM 3/17/2005, John Jones wrote: > >>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 > > >>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 > >With binary removed there seems to be a dramatic speed up. > >With your new version of SQL.pm > >[Thu Mar 17 11:16:24 2005] 38563 1111076184 - [/webwork2/mth162/7/6/] >[runTime = 2.0 sec sql_single] >[Thu Mar 17 11:16:28 2005] 38563 1111076188 - [/webwork2/mth162/7/6/] >[runTime = 3.0 sec sql_single] >[Thu Mar 17 11:16:31 2005] 38563 1111076191 - [/webwork2/mth162/7/6/] >[runTime = 2.0 sec sql_single] >[Thu Mar 17 11:16:35 2005] 38565 1111076195 - [/webwork2/mth162/7/6/] >[runTime = 3.0 sec sql_single] >[Thu Mar 17 11:16:38 2005] 38565 1111076198 - [/webwork2/mth162/7/6/] >[runTime = 3.0 sec sql_single] >[Thu Mar 17 11:16:41 2005] 38565 1111076201 - [/webwork2/mth162/7/6/] >[runTime = 2.0 sec sql_single] >[Thu Mar 17 11:17:05 2005] 38564 1111076225 - [/webwork2/mth162/8/8/] >[runTime = 3.0 sec sql_single] > >With the old version of SQL.pm but with binary removed > >[Thu Mar 17 11:17:07 2005] 38564 1111076227 - [/webwork2/mth162/8/] >[runTime = 0.0 sec sql_single] >[Thu Mar 17 11:17:09 2005] 38564 1111076229 - [/webwork2/mth162/8/11/] >[runTime = 0.0 sec sql_single] >[Thu Mar 17 11:17:42 2005] 48562 1111076262 - [/webwork2/mth162/7/6/] >[runTime = 1.0 sec sql_single] >[Thu Mar 17 11:17:44 2005] 48564 1111076264 - [/webwork2/mth162/7/6/] >[runTime = 1.0 sec sql_single] >[Thu Mar 17 11:17:44 2005] 48562 1111076264 - [/webwork2/mth162/7/6/] >[runTime = 0.0 sec sql_single] >[Thu Mar 17 11:17:45 2005] 48562 1111076265 - [/webwork2/mth162/7/6/] >[runTime = 0.0 sec sql_single] >[Thu Mar 17 11:17:46 2005] 48564 1111076266 - [/webwork2/mth162/7/6/] >[runTime = 0.0 sec sql_single] >[Thu Mar 17 11:17:47 2005] 48564 1111076267 - [/webwork2/mth162/7/6/] >[runTime = 0.0 sec sql_single] >[Thu Mar 17 11:17:48 2005] 48562 1111076268 - [/webwork2/mth162/7/6/] >[runTime = 0.0 sec sql_single] >[Thu Mar 17 11:17:49 2005] 48575 1111076269 - [/webwork2/mth162/8/11/] >[runTime = 1.0 sec sql_single] >[Thu Mar 17 11:17:49 2005] 48564 1111076269 - [/webwork2/mth162/7/6/] >[runTime = 0.0 sec sql_single] >[Thu Mar 17 11:17:50 2005] 48564 1111076270 - [/webwork2/mth162/7/6/] >[runTime = 1.0 sec sql_single] >[Thu Mar 17 11:17:51 2005] 48562 1111076271 - [/webwork2/mth162/7/6/] >[runTime = 0.0 sec sql_single] > >If using case insenstive keys does not mess up how things are read out >(e.g. you want set "Exam1" to be in that form, not e.g. "EXAM1" or >"exam1"), then it should be easy to enforce that there are no conflicts >when userid's, set names, etc are created. > >Since I can not imagine that we have any database keys which differ only >in case, I'll try this out now. > >Thanks. > >Arnie > > > >------------------------------------------------------- >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 |
