Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    11

    Question Unanswered: Superslow database on Windows 2003 server

    I have a new server with Windows 2003 Server and MySQL on it. The database is terrible slow though. I compare the speed to the same database on another pc with Win XP and on the server calls to the database is 1000 times slower! And then I have used the exact same code and I have nothing else running in the background. When I do another test without using the database the Server is faster as it should be. So the problem has something to do with the database.

    Any ideas?

  2. #2
    Join Date
    Dec 2005
    Posts
    11
    I add more information I just discovered. The server works slower on .vbs-files while working with .asp-files it is fast. So something is causing the server to be extremely slow when it comes to working towards the MySQL-database through .vbs-files, everything else works fast and fine. What is it with that perticular combination?

  3. #3
    Join Date
    Apr 2006
    Location
    Denver, Co. USA
    Posts
    242
    I have seen other posts about Windows servers and slow mysql that concern name lookup and DNS/reverse DNS (even when using an ip address.) Here are a couple of posts concerning a solution for this -
    http://www.vbmysql.com/forums/index....428%09&start=0
    http://codebetter.com/blogs/ben.reic...dows_2003.aspx

    In your case, I suspect that the library being used to interface between .asp and mysql does not exhibit this problem, but the .vbs to mysql interface does.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •