I have a directory and I bought a paid MySql database with 1.2 million entries. My current programmer uploaded this on my server, but the site has become snail slow. He is trying to figure out how to get the site to speed up but is unable to determine a solution. Does anyone have a solution for this? If you are good with databases and know the solution for this let me know. I can pay you for this since my current programmer couldn't figure it out. Thanks!
Please provide details about your experience with Databases and any jobs you currently worked on. Before I start working with anybody, I want to make sure they are appropriately qualified. Thanks!
Ash, the solution would be switching to a different content management script since the current one won't be able to handle the database load unless recoded. You can't "change a few things" to get it to work, and when it comes to upgrades you're in trouble again, so it's best if you just focus on a different solution. What script is your site currently based on?
Hi , I can fix it and make it super fast. I did a lot of huge database site like : 50 million record database site. Thanks,
Actually you can. I assume that your database uses no indexes whatsoever, which makes whole application slow, even fields types can be optimized. Also, the problem maybe type of tables you use - MyISAM are fast, but they do not offer the features that InnoDB has (on the other hand you may not need that features at all) and so on. In the end a lot depends on how you are using data in the table. Do you need access to all 1.3 milion records at once, are queries using indexes, are you caching results and most importantly are queries optimized?
the database server resources can also play a factor, you can have the most efficient code, but if your server cant handle the load, then everything is for naught