||Our oscommerce shop (MS2 RC2a version) have a load time / high server load issue.
Please visit the...in example of "other customers also bought..." query.
We want better perfomance on the site, because...must provide full documentation of file changes, database changes and updates, so that we can implement
||PHP, Shopping Carts, eCommerce, OSCommerce, MySQL
||Jan 14, 2012
||Jan 14, 2012Ended
|Database & Query Optimization
||...optimize the query speed of my website. It current has a multi-attribute based web query front end kicking...kicking off a query for a mySQL database with about 2M records. Would like to atleast double the speed
||PHP, Windows Desktop, Linux, Engineering, Software Architecture, Mac OS, Software Testing, Website Testing, Chrome OS, MySQL, UNIX, Website Management, Web Hosting
||Nov 2, 2006
||Nov 2, 2006Ended
|Simple Database Query optimization
||...right now showing me timeout due to one sql server query
You must be able to work on my machine using
||Feb 11, 2014
||Feb 11, 2014Ended
||...configure mysql for my store based on oscommerce.
Also I need query optimizaton and enable cache for all
||PHP, Shopping Carts, MySQL
||Oct 1, 2010
||Oct 1, 2010Ended
|mysql database table and query optimization
||...server side mysql optimization has been done, requires tables and re-designing of query Issue: - We have...mysql, php as you may have to re-write the mysql query that script uses to reduce load or table locks -
||Dec 10, 2012
||Dec 10, 2012Ended
|MYSQL Database Overhaul ( Query optimization)
||1. Guys we need to do a complete database optimization
2. You will be working with another coder on...on this project to test query speeds
3. You may have to rewrite the query.
The site is php based...only bid if you have good experience in SQL optimization.
||Sep 25, 2009
||Sep 25, 2009Ended
|Joomla 2.5 database query optimization
||...an offer and also time table for optimizing the database.
||PHP, Software Architecture, Website Testing, MySQL, Website Management
||Oct 19, 2013
||Oct 19, 2013Ended
||...importance of Query Optimizers in relational DataBase Systems
Analyze different optimization techniques...techniques to find the optimal plan for a given query. Some of them are:
2. Dynamic Programmic
||Copywriting, SQL, Technical Writing, Academic Writing, Article Rewriting, MySQL, Database Administration
||Mar 25, 2008
||Mar 25, 2008Ended
|oscommerce database optimization
My site www.mrtees.com is an oscommerce ecommerce site that sells t shirts and other types of...might have to do with the way the products and database is setup. There was a lot of customization done
||PHP, Shopping Carts, SQL, eCommerce, OSCommerce
||Mar 17, 2011
||Mar 17, 2011Ended
|MySQL cluster query optimization
||We have a large database that's recently had tables converted from InnoDB to NDB to allow for more concurrent...now getting stuck.
Database and table structure are in details. The database currently has 23 million...queries will freeze.
1 - Database server. 96GB RAM, 4 x 146GB SAS in RAID10, 2 x
||PHP, Software Architecture, Software Testing, Website Testing, Amazon Web Services, Website Management, Database Administration, Web Hosting
||Dec 16, 2011
||Dec 16, 2011Ended
||...to Tweak the performance of Existing Query and Check the database design.
And provide suggestion and...and do implement the best database design.
||PHP, Website Design, HTML, Database Administration
||Jan 11, 2014
||Jan 11, 2014Ended
|MySQL Query Optimization
||...mysql database table with 250,000 rows, however i have basic mysql query knowledge and the query i am...be the best way to preform searches against a database of this size as I am experiencing wait time when
||PHP, Project Management, Engineering, Software Architecture, Software Testing, MySQL
||May 4, 2010
||May 4, 2010Ended
|Oscommerce MySQL Database Optimization
||We use oscommerce to build our store RuthiesMusic.com. Currently, we have about 10,000 products. Typically...too many products for oscommerce to handle. We have talked with other oscommerce users and tried all their...restoring our oscommerce database. We can not use the built in backup/restore feature with oscommerce as it times
||PHP, Linux, Engineering, SQL, Software Architecture, Software Testing, MySQL, UNIX
||Jul 16, 2003
||Jul 16, 2003Ended
I own an oscommerce shop and is running very slow specially when you enter to see the description...product. We think it might have to do with the mysql database.. we are looking for someone to look into the
||Shopping Carts, SQL
||Jul 15, 2009
||Jul 15, 2009Ended
|SQL query optimization
||I have a contact management database that uses lots of many to many relationships using intermediate...tables. The problem I have is that when I want to query a "complete" record (lots of data from other tables)...approximately 6500 contacts in the database and it times out on the current query I'm using when I want to retrieve
||PHP, Engineering, SQL, Software Architecture, Software Testing, MySQL
||Oct 25, 2004
||Oct 25, 2004Ended
|40474 Query optimization
We have a database with over 35000 records, We have a query to generate few results from that...that DB which involve 5 tables. This query is taking too much time to execute and display records.
We want...this query so that results are shown in few seconds.
Pls contact through PMB to get the query and DB
||PHP, Anything Goes
||Dec 8, 2005
||Dec 8, 2005Ended
|SocialEngine sql query optimization
||...those queries which are causing extra load to database. I will require a detailed documentation what...
Also you have to show that you optimization has reduced database load at least 20%.
||Linux, SQL, Social Engine
||Dec 31, 2009
||Dec 31, 2009Ended
|MySQL Query + Optimization
||We need a mysql query returning a result from 5 tables. The result may not using filesort and temporary...and fully-functional query running with the example database/tables
2) The query may use indexes for...for best performance. The query may not use filesort or temporary tables
3) Examples for querys searching
||PHP, Engineering, Software Architecture, Software Testing, MySQL
||Oct 16, 2007
||Oct 16, 2007Ended
|oscomerce mysql query optimization
||...other sites we are working on.
I have the database on another server because I was trying multiple...thing can slow to a crawl so I need to get the query time fixed.
||Aug 4, 2008
||Aug 4, 2008Ended
|86086 MySQL query optimization
||MySQL query optimization
I suspect this is an easy task for an experienced MySQL / php programmer. ...file has the benchmark scripts, one populates a database with 1M records (takes 198 seconds and takes up...contains the select statement.
1) Please create a database on your server and populate it using the attached
||PHP, MySQL, Anything Goes
||Sep 23, 2006
||Sep 23, 2006Ended