Re: [nyphp-talk] Table Indexes

On Sat, Sep 27, 2008 at 8:32 PM, Daniel Convissor <[EMAIL PROTECTED]> wrote: > Hi John: > > On Sun, Sep 07, 2008 at 02:31:48PM -0400, John Campbell wrote: >> >> With MySQL the fastest is often: >> Primary(a,b) >> index(b) > > I agree. > > >> And in sometimes you even want: >> Primary(a,b) >> index(

Re: [nyphp-talk] Table Indexes

Hi John: On Sun, Sep 07, 2008 at 02:31:48PM -0400, John Campbell wrote: > > With MySQL the fastest is often: > Primary(a,b) > index(b) I agree. > And in sometimes you even want: > Primary(a,b) > index(a) > index(b) The second index of "a" would duplicate the index of "a" in the primary key.

Re: [nyphp-talk] Adding PostgreSQL with an XAMPP Install

I never said it wasn't a good DB. I just said it wasn't MySQL whichI had up and running for several years and was used to using I got it installed and running. Thanks Joey Justin Dearing wrote: Joey, Postgresql is a very good database. Its got a featureset closer to Oracle or MS SQL. But eno