Optimize MySQL Statement
€30-250 EUR
Paiement à la livraison
I need this statement to be optimized or a caching solution, as it seems to cause speed problems and breaks the server.
I need a very fast solution. So please in your application state what you think is wrong or can be optimized and I will pay you for the solution.
This is the MySQL Statement:
SELECT [login to view URL], [login to view URL], [login to view URL], [login to view URL], COUNT([login to view URL]) AS user_votes FROM cs_users AS u LEFT JOIN cs_users_votes AS v ON [login to view URL] = [login to view URL] WHERE [login to view URL] = '526' AND [login to view URL] = '1' AND [login to view URL] = 'de_DE' GROUP BY [login to view URL]
It will generate a preview of participants of a Photocontest for in this case 33 Pages with 12 image each.
Nº du projet : #10784876
À propos du projet
20 freelances font une offre moyenne de 149 € pour ce travail
PHP,PDO, Core-php, CakePHP, CodeIgniter, Laravel, Yii, Mysql, HTML, HTML5, CSS, JavaScript, Angular js, jquery, AJax, Joomla, E-Commerce, Content Management System, Magento, Wordpress, Woo-commerce, PrestaShop, Drupal Plus
Hi, In my current Professional Microsoft Senior SQL Server DBA role, I have extensive experience with SQL Server versions 2000-2016. I have immense experience working with data management on a daily basis for a Mul Plus
Your query seems to be optimum. I suppose the problem is in datatype assigned to each of the columns in both the tables and indexing of the foreign key. Please discuss and share the database schema to provide a better Plus
Guten Tag, es liegt sehr wahrscheinlich an den Indizes für die Tabellen cs_users und cs_users_votes. Wenn die Menge der Daten beider Tabellen groß ist, erfolgt für jeden Eintrag ein gesamter Tabellendurchlauf in cs_ Plus
Hi, I'm from Venezuela. I have experience working with MySQL and I think I can help you to fix this problem.
Hi, What is the number of entries in your database and do you have non-clustered indexes set? Kind Regards, Vladan