I have just created a new site for home based businesses.

http://homebusiness.civicvoice.com

This site is built using technology provided by the Drupal content management system.

If you have been keeping up with web development for the last year or so, you have probably hear of AJAX, which stands for "Asynchronous JavaScript and XML".

AJAX is based on JavaScript and HTTP requests. When an action is performed on a page, JavaScript code is called which performs a HTTP request back to the server to get more information to be shown on the page.

To use AJAX, you use the nonstandard XMLHttpRequest object to communicate with server-side scripts.

It appears that using AJAX would negatively impact the crawling of your site by search engines.

MySQL is to Oracle as Linux is to Windows.

Limiting Result Sets

Oracle supports ROWNUM to limit the result Sets

SELECT *
FROM tablename
WHERE rowmun < 10


MySql uses the LIMIT clause.

SELECT *
FROM tablename
LIMIT 10

Bind Variables
The latest versions of MySql supports bind variables, and Oracle has supported bind variables for a very long time. Just a slightly different syntax, but the same thing can be accomplished with both MySql and Oracle bind variables.



Sequence Numbers
In Oracle you create a sequence object.

In MySql, you set an attribute on a column to be AUTO_INCREMENT, when NULL is inserted into an AUTO_INCREMENT column, the next value is entered.



Licensing Costs
Oracle licensing can be in the hundreds of thousands of dollars for a multiprocessor server.
MySql is a free opensource database, and has no licensing.

So, which is better, MySql or Oracle?
Either may be better, depending on your needs. The right answer might be both. Using one database doesn't preclude you from using another. It might make sense to use Oracle for data warehousing, and then to use MySql for data warehousing, or possibly the opposite.

Need Oracle or MySql Tuning Support?
Steve Stedman now offers performance reviews of your Oracle or MySql databases. Contact Steve for help with Oracle and MySql.