MySQL Table design

MySQL Table design

El Forum
Guest

03-30-2009, 07:32 PM

[eluser]jedd[/eluser]
You mean a SELECT * WHERE listing_id=$x .. ? I'd certainly be INDEXing all the columns there (not sure how useful that is on the attribute column, but nonetheless). I think the database will be pretty snappy with such requests. You can crank up some test data if you are concerned, though.

Messages In This Thread

MySQL Table design - by El Forum - 03-30-2009, 04:24 PM

MySQL Table design - by El Forum - 03-30-2009, 04:41 PM

MySQL Table design - by El Forum - 03-30-2009, 05:05 PM

MySQL Table design - by El Forum - 03-30-2009, 07:16 PM

MySQL Table design - by El Forum - 03-30-2009, 07:32 PM

MySQL Table design - by El Forum - 03-30-2009, 07:34 PM

MySQL Table design - by El Forum - 03-30-2009, 08:35 PM

MySQL Table design - by El Forum - 03-31-2009, 05:24 AM

MySQL Table design - by El Forum - 03-31-2009, 07:53 AM

MySQL Table design - by El Forum - 03-31-2009, 08:04 AM

MySQL Table design - by El Forum - 03-31-2009, 11:59 AM

MySQL Table design - by El Forum - 03-31-2009, 10:01 PM

MySQL Table design - by El Forum - 03-31-2009, 10:04 PM

MySQL Table design - by El Forum - 03-31-2009, 10:34 PM

MySQL Table design - by El Forum - 04-01-2009, 07:20 AM