Re: [WWdevel] speed of WeBWorK/mysql

[Sam H. <sh...@ma...>]

\On Mar 2, 2005, at 10:20 PM, Arnold Pizer wrote:

> At 09:45 PM 3/2/2005, Sam Hathaway wrote:
>> On Mar 2, 2005, at 10:35 AM, Arnold Pizer wrote:
>>
>>> My students in MTH 162 are seeing a significant slowdown in WeBWorK 
>>> this semester and I'm not sure what is going on.  I'm wondering if 
>>> any of you have seen similar things or if the symptoms bring to mind 
>>> what the problem might be.
>>
>> If someone's feeling ambitious, they could write a custom version of 
>> DB.pm that makes SQL calls directly. I think we could get some 
>> savings if we avoided the "Schema" abstraction.
>> -sam
>
> Hi Sam,
>
> The slow downs I'm seeing are significant --- e.g. 40 times slower 
> than what we are used to.  Could the "Schema" abstraction have that 
> great an overhead?

It can't account for all of the slowdown, but I think there's room for 
significant improvement. I'll take a closer look once devel is back up.
-sam