[PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread Jason Pruim
Good morning everyone! Hope you all have your coffee in hand when reading this :) In case it makes a difference, It will be written in PHP 5.2.6 and using mysql 5.0.51a-community with apache 2.2.9. I am in the planning stages of a project that will turn into a customer relation management

Re: [PHP-DB] oci driver performance

2008-10-20 Thread Christopher Jones
Chris wrote: > Hi all, > > Using php 5.2.6 + oci driver 1.3.4 from pecl > > Has anyone had any issues with the oci8 driver performance? > > I'm doing some profiling using xdebug and all of the time seems to be > spent in oci_execute and oci_fetch_array. This shows up when I use > jmeter to hit t

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread TG
First I have to give the caveat... there will be different thoughts on the best way to handle this. Some will be "more right" than others. I'm not going to pretend I'm the DB expert, but I've seen quite a few different schema styles in my day. I've seen ones that made sense to me and others

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread Bastien Koert
On Mon, Oct 20, 2008 at 7:59 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: > Good morning everyone! > [snip][/snip] > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > I would suggest breaking the client and contacts into two tables. It

Re: [PHP-DB] When does using multiple tables make sense?

2008-10-20 Thread Lester Caine
Jason Pruim wrote: So my question is... When is it best to use more tables? All the info will be related to each other, so I think I would be looking at either a many-to-many relationship, or a many-to-one relationship (still figuring that out). One thing that I've realised make sense is to h

[PHP-DB] mysql_select_db

2008-10-20 Thread Stan
UBUNTU Server v8.04 On a web page: CODE: require_once 'frames_includes/navigationDB.inc'; $navigation_connection = mysql_connect($navigation_hostName, $navigation_userName, $navigation_passWord) or die("Failed to conne

Re: [PHP-DB] mysql_select_db

2008-10-20 Thread Stut
On 20 Oct 2008, at 13:03, Stan wrote: UBUNTU Server v8.04 On a web page: CODE: require_once 'frames_includes/navigationDB.inc'; $navigation_connection = mysql_connect($navigation_hostName, $navigation_userName, $navigati