slow responseRSS

1 reply

Last post Sep 20, 2015 02:44 AM by hostingaspnet

  • slow response

    Feb 23, 2015 04:43 AM|faizmir|LINK

    on fetching the database mysql it takes 4-5 minutes
  • Re: slow response

    Sep 20, 2015 02:44 AM|HostingASPNet|LINK

    Hello,

    You should make your tables innodb, and to optimize the MySQL options via my.ini. Also, run Optimize on the MySQL tables. MySQL needs a lot of RAM, especially if your database is big and if you use Plesk it has 3GB memory limit because it uses 32 bit MySQL version. You should install 64 bit version if needed or wait for the new Plesk version which will support it.

    Regardss

    WindowsHostingASP.NET - My favourite site for Windows and IIS hosting information.
    HowtoASP.NET - Free ASP.NET tutorials and source code.