Tuesday, September 24, 2019
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.
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 (<fugee279@gmail.com>) escribió:
--
On Tuesday, September 24, 2019 at 12:37:37 AM UTC-4, hasan...@gmail.com wrote:[response inline]On Mon, 23 Sep 2019 at 21:32, fugee ohu <fuge...@gmail.com> 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--If you wish to request my time, please do so using bit.ly/hd1AppointmentRequest.Si vous voudrais faire connnaisance, allez a bit.ly/hd1AppointmentRequest.Envoye de mon portableI 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 rubyonrails-talk+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/63f7e9f5-eb9a-4618-8ed9-d1f78f3a05b8%40googlegroups.com.
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 rubyonrails-talk+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAPS3bcDahpvTP45hFT6Gi58iaWL2TTXJGxYsqJeWvojQy%2B31%2BQ%40mail.gmail.com.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment