Another option (if your database accepts it, like postgres or newer MySQL versions) is to use a column with JSON or JSONB type. You could have a json object with all property/value pairs. I'm not sure about performance, indexing, etc on JSON columns though.
I'm not sure what are the categories you are talking about now, you mean the "auction type"? You'll have to have many many millions of auctions in order to make the auction_properties tables too large (if your ID is an int, you have 2,000 MILLION ids to use, if you use bigint I don't even know that number, you'll need really good indexes though haha), and even if you ever get near some critical situation you could split table by auction type or something like that. I doubt it's something you have to worry about right now, you'll have a lot of more important things to improve before reaching that. El mar., 24 sept. 2019 a las 19:19, fugee ohu (<[email protected]>) escribió: > > > On Tuesday, September 24, 2019 at 12:37:37 AM UTC-4, [email protected] > wrote: >> >> [response inline] >> >> On Mon, 23 Sep 2019 at 21:32, fugee ohu <[email protected]> wrote: >> >>> But then a single item will contain many records, one for each property, >>> wouldn't that create too-large-tables? >>> >> >> By the time that becomes a problem, you'll have bigger things to worry >> about it, mate. -- H >> >> -- >> OpenPGP: >> https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1 >> If you wish to request my time, please do so using >> *bit.ly/hd1AppointmentRequest >> <http://bit.ly/hd1AppointmentRequest>*. >> Si vous voudrais faire connnaisance, allez a *bit.ly/hd1AppointmentRequest >> <http://bit.ly/hd1AppointmentRequest>*. >> >> <https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1>Sent >> from my mobile device >> Envoye de mon portable >> > > I can't make up my mind First, there's countless types of items Next they > may use the category in deciding which form to load We haven't take > categories into account yet in this discussion > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/63f7e9f5-eb9a-4618-8ed9-d1f78f3a05b8%40googlegroups.com > <https://groups.google.com/d/msgid/rubyonrails-talk/63f7e9f5-eb9a-4618-8ed9-d1f78f3a05b8%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAPS3bcDahpvTP45hFT6Gi58iaWL2TTXJGxYsqJeWvojQy%2B31%2BQ%40mail.gmail.com.
