If you are trying to install Oracle database product(s) on Suse Novell Linux 10 SP 3 you may experience problem with missing compat rpm package. Novell SLES actually provides all the necessary files via libstdc++33 howerver Oracle installation doesn’t really recognize it and reports missing compat libstdc++ package.

If you have installed you may remove the following packages running the following rpm command:

rpm -e libstdc++33
rpm -e libstdc++33-32bit

A good alternative is to find a compat libstdc++ package from SLES 10 SP 2 and it works perfectly. The compact-libstdc++ package you need is as follows:

compat-libstdc++-5.0.7-22.2.x86_64.rpm

Download it and install it running:

rpm -ivh compat-libstdc++-5.0.7-22.2.x86_64.rpm

Enjoy!

The less data your website pulls from the back-end MySQL server, the faster it is. Imagine you need to display just 3 rows from a table with 2,500 records, but your code is looping through all 2,500 records generating extra, unnecessary load.

For example:

SELECT name,lastname from UserTable;

Optimized SQL query would be:

SELECT name,lastname from UserTable Limit 3;

Or, for example, you have a blob record of an article with 550 words and you want to display only the first 50 characters for the excerpt. Why do you need to pull out all 550 words if you can write a query that is friendlier and works much faster?

SELECT title, SUBSTRING(article,1,50) from ArticleTable Where Id=”5″;

The key to the optimization is writing smart code and always optimizing for performance.

Optimize MySQL queries:

To pull only data you need,
Limit loops,
Limit answer length when needed,
Use correct indexes,
Use MySQL caching settings.