Thanks, something is eathing the replies, I had to get it off of google,
it never came to me. Will check it out.
>Tim Bunce ([EMAIL PROTECTED]) said:
>Use the DBI's built in profiling to see where the time is being spent.
>
> perldoc DBI::Profile
>
>Tim.
>
>On Thu, Dec 11, 2003 at 11:19:13AM -0800, William R. Mussatto wrote:
>> System: WinNT 4.0 Server (sp 6a). IIS 4
>> ActiveState perl 5.8.
>> MS SQL server.
>>
>> When I went from Win32::ODBC to DBI::DBD-ODBC response time doubled so
>> that complex pages went to 20 seconds from about 7 seconds. Granted @
>> 200MHz Pentium its not a fast box, but still... Interestingly going from
>> .plx to .pl did not affect the speed (if anything its faster). Any ideas?
>>
>> I'm in the process of moving the whole lot to linux and MySql, hence the
>> switch.
>>
>> BTW: if you hit stop on a browser when .plx is running the web server
>> usage goes to 100%.
>>
>> There remains free memory so that isn't an issue. There is virtually
>> nothing else going on the box...
>>
>> I've googled but didn't see any hits.
>>
>> William R. Mussatto, Senior Systems Engineer
>> Ph. 909-920-9154 ext. 27
>> FAX. 909-608-7061
