Newest Articles For Database

Using Partitions in Oracle databases
By John Henry Xu - Mon Jul 18, 2005 9:36:12 PM ET
From Oracle database 8.0, Partitions have been introduced to improving large database tables. Database table partition is physically save table data in different tablespaces that are located in different hardware disks. Database table partition thus reduced I/O operation when database operates on ...

Optimizing and Tuning Your MySQL Database
By SAMS - Thu Jun 2, 2005 8:54:54 PM ET
Proper care and feeding of your MySQL server will keep it running happily and without incident. The optimization of your system consists of proper hardware maintenance and software tuning, as well as the database design methods you've learned throughout this book.
Now you will learn Basic ...

Use PostgreSQL and PHP on Windows
By James Williams - Sat May 29, 2004 9:20:52 AM ET
I guess every SitePoint visitor has seen the words "Database Driven Website Using PHP & MySQL" a million times. Something you don't see every day is the combination "PHP & PostgreSQL" -- especially not with the post-script, "...on Windows". Some people think it is incredibly difficult to run PostgreSQL ...