2nd post: DBD::ODBC slower than Win32::ODBC

From: William R. Mussatto (mussatto_at_csz.com)
Date: 12/11/03 

Date: Thu, 11 Dec 2003 11:19:13 -0800 (PST)
To: <dbi-users@perl.org>

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

Relevant Pages

  • Re: Getting list of recently added IDENTITY items
    ... num_of_hits for each hit within the same 3ms timeframe. ... The problem is fairly apparent here, because SQL Server has a fairly ... floating-point as a primary key. ... IDENTITY is a discrete set of value that is easy ...
    (comp.databases.ms-sqlserver)
  • Re: Virtual PC emulation of PIII
    ... to emulate anything better than a Pentium II on these machines. ... SQL Server is just a back-end to a database server... ... This feature ONLY works when SQL Server is run on ... MAC because it requires a Pentium III or greater. ...
    (microsoft.public.mac.virtualpc)
  • Re: Virtual PC emulation of PIII
    ... to emulate anything better than a Pentium II on these machines. ... SQL Server is just a back-end to a database server... ... NO, it couldn't, we use the new SQL Express feature of user instances ... MAC because it requires a Pentium III or greater. ...
    (microsoft.public.mac.virtualpc)
  • Re: Null Values
    ... Am using SQL Server 2000. ... Have been using VB for years and never hit any serious data problems like ... sure where to place the fix code, or what data object to apply it to. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Null Values
    ... > Am using SQL Server 2000. ... > Have been using VB for years and never hit any serious data problems like ... > not sure where to place the fix code, or what data object to apply it to. ...
    (microsoft.public.dotnet.framework.adonet)