User Profile

Collapse

Profile Sidebar

Collapse
goozak
goozak
Last Activity: Apr 26 '11, 09:05 PM
Joined: May 4 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • goozak
    replied to SQL Express - Slow response time on all but one machine
    in SQL Server
    Found it !! The problem was twofold:
    1. The PHP code configured the sqlsrv DLL to log EVERYTHING (SQLSRV_LOG_SYS TEM_ALL & SQLSRV_LOG_SEVE RITY_ALL) - these get logged in Apache's ErrorLog.
    2. I was using RotateLogs in Apache for our ErrorLog and a CustomLog on my development machine.

    The PHP is not my code, I'm starting a new job and the original programmer already left the company. Since it was working fine on my machine, I never...
    See more | Go to post

      Leave a comment:

    • goozak
      replied to SQL Express - Slow response time on all but one machine
      in SQL Server
      Well, still no luck... We tried with TCP/IP, Shared Memory & Named pipes but got the same result. SQL Server is slow on every machine we test on, except my own computer. I even uninstalled SQL Server and reinstalled it - it's still running fine !

      Why does Oracle charge so much to include MySQL in our software? We have no speed problem with MySQL... :-(...
      See more | Go to post

        Leave a comment:

      • goozak
        replied to SQL Express - Slow response time on all but one machine
        in SQL Server
        Thanks CK for your help. Yeah, everything is on the same machine (SQL Express & Apache). It's a stand alone product that will be installed on a single machine used by a single user. The code base is the same as the corporate, web server version.

        I removed most of the cursors from the queries, but with marginal gain in speed. Other SQL events are taking a long time too, like "USE dbName" (duration of 976 on my machine,...
        See more | Go to post

          Leave a comment:

        • goozak
          started a topic SQL Express - Slow response time on all but one machine
          in SQL Server

          SQL Express - Slow response time on all but one machine

          Hello,

          I'm working on a web application using Apache (2.0.55), PHP (5.2.8) & SQL Server 2008 Express (using the Microsoft provided php extension php_sqlsrv_52_t s_vc6.dll) and I have a speed problem with SQL Server Express.

          On my development machine, everything works fine. But when I setup other computers, the SQL Express takes much longer to respond.

          My development machine is a 3GHz Core2 Duo with...
          See more | Go to post
          No activity results to display
          Show More
          Working...