Re: PHP and ORACLE

Ricardo Fitzgerald wrote:

Hi, I started with PHP and MYSQL a while ago and now I've been involved in a huge database project with ORACLE. -----------snip---------------

And i don't have any kind of experience with Oracle, so I would appreciate any recommendations from experienced developers. I develop a lot with Oracle (pl/sql not php) but I think the key factors remain the same with a small or large amount of data. Spend time ensuring the table layout (and its indices) are fairly optimal. With a small amount of data extra time in doing sql statements may not be critical, but with a lot of data it would be very noticeable.

Two of the Oracle CDs in the distribution are documentation. MostOne of the books on them is the Server Applications Developer's Guide, some of the information on table layout and general optimising may be useful, but most of it is about using pl/sql. Otherwise just ensure the database is doing all your sorting etc, and gives you the data in the order you need it. This doesn't seem much advice, but its a start. Post anything else more specific. Hope it helps. Chris PS Your computer clock tells me I'm a teenager again!