|Optimize SQL queries by Virtuemart
||We have a problem on our, something is making enormous amount of queries to DB. Just loading a page loads 1400 queries. This make the site almost unreachable. I can give more details if requested.
||PHP, Joomla, MySQL
||Dec 30, 2010
||Dec 30, 2010Ended
|Optimize MySql database - Virtuemart - Joomla 2.5
||Virtuemart store has 10's of thousands of products and is running rather slow.
A search module...performed and this will not work.
Several methods of sql optimizations could be tried , im interested in any
||Joomla, SQL, MySQL, Virtuemart
||Nov 8, 2013
||Nov 8, 2013Ended
||optimize the following sql & exclude NULL phonename, companyname & purchase date, currently takes about
||Dec 13, 2013
||Dec 13, 2013Ended
||I have a large database that is called very frequently.
it is growing very fast and now has over a million entries.
my requests take 30 seconds and i need them down much faster
i have some indexes on the database but i don't understand them very well.
i would provide access to a git repository of a cakephp project and a dump of the database for you to get running and work on locally.
||CakePHP, MySQL, Database Administration, Database Programming
||Jun 7, 2014
||Jun 7, 2014Ended
|Review and Optimize SQL
||We have a rather complex SQL statement that is unoptimized. Our web application is accessed around a...qualified DBA to look at the enclosed description and SQL statement, along with the enclosed sample data, and...application runs on both MySQL as the backend and SQL server (via Azure) and the optimizations should work
||Software Architecture, Database Administration
||Sep 9, 2011
||Sep 9, 2011Ended
|Optimize sql database - repost
I have a few site that are running on Wordpress. All hosted on the same Cpanel.
Combined there are 50k visitors a day and the server CPU is often maxing out at 100%. I have a good hosting package, 4GB Ram, 100 processes , Quad Core, etc so it should be able to handle this amount of traffic.
As I have little experience in this field, I am looking for someone to optimise the database...
||Sep 4, 2013
||Sep 4, 2013Ended
|Optimize SQL Query
||Optimize the following query. The Inner Select statement significantly slows down the query.
||Nov 11, 2014
||Nov 11, 2014Ended
|Optimize SQL query in OSCommerce
||Our oscommerce shop (MS2 RC2 version) have a sql query issue.
Please visit the test store here:
||Jan 26, 2010
||Jan 26, 2010Ended
|Optimize SQL Queries (SQL Server)
||I need someone to improve the SQL queries of the database attached. Create the proper indexes if needed
||Mar 26, 2012
||Mar 26, 2012Ended
|Optimize SQL Server query
||...coder's Seller Legal Agreement).
SQL Server 2005
||Mar 6, 2010
||Mar 6, 2010Ended
|194455 Optimize SQL query
||...top of the page.
When someone uses this form, SQL like the following is created -
select * from...limit 0, 70
Unfortunately MySQL is not able to optimize this query. It executes "Copying to tmp table"
||MySQL, Anything Goes
||Jan 23, 2008
||Jan 23, 2008Ended
|496909 Optimize SQL searches
||...have web application written in asp.net and using a SQL Server database, which can be very large. Users...is very slow. We need someone who can help to optimize this search.
||ASP, .NET, SQL, Anything Goes
||May 8, 2011
||May 8, 2011Ended
|oracle sql optimize
||...18 sql statements (with joins, union.. etc). i would want expert to help me optimize these 18 sql statements...etc
please prove your past experience on sql optimization with ORACLE
my budget usd5. pay through
||Dec 9, 2011
||Dec 9, 2011Ended
|Optimize SQL Queries
||...the database. The main-goals of this project: -Optimize the queries so they can be run during the day...or converted to perl but I include it because the SQL can be used from it. I am also attaching the current
||PHP, Perl, Linux, Engineering, Ruby on Rails, SQL, Software Architecture, Software Testing, MySQL, Database Administration
||Nov 22, 2007
||Nov 22, 2007Ended
|Optimize php sql script
||Modify php / mySql code in the attached file to operate faster.
A loop of a database with about 7000 records, and updating a separate table with the data, is taking about 37 seconds to complete.
In your bid, please specify that you know how to do this, and the number of hours you expect to take to complete the work.
||PHP, Software Architecture, MySQL
||Feb 14, 2013
||Feb 14, 2013Ended
|Optimize SQL Queries
I need to Optimize SQL Queries for a prestashop plugin. The problem is when I generate 4 colors
||PHP, SQL, Prestashop, MySQL, HTML
||Oct 14, 2014
||Oct 14, 2014Ended
|Optimize sql indexes
||I have a website which has a large database of content that is running slow and needs to be indexed. I am looking for someone who is an expert in optimizing databases.
||ASP, .NET, SQL
||Sep 14, 2010
||Sep 14, 2010Ended
|Alter and Optimize sql query
||I need someone to please change this SQL query to NOT use sub-query with IN, I need for this query to
||Dec 10, 2013
||Dec 10, 2013Ended
|Optimize sql query
||...com/) as a framework and I am stuck on a certain sql query
Currently I want to retrieve paginated data
||Nov 19, 2013
||Nov 19, 2013Ended
|fix and optimize sql
||i have website sql and there is some error in it i need to fix it and optimize it too
||PHP, Java, SQL, MySQL, HTML
||Mar 14, 2015
||Mar 14, 2015Ended