Why not use a BigIntegerField? On Sat, Aug 1, 2015 at 12:06 AM, jordi collell <[email protected]> wrote:
> Hi all! > > I have to store spreadsheet info on a db. Some kind of quotes where the > user can store distinct prices for every zone. > > After modeling the data, i have a Cell like row. (related to a zone, and > with a quantity field).. something like: > > zone1 1 100 > zone1 2 99 > zone1 3 98 > > Every zone is a fk... The problem is, that data grows quick.. because some > quotes can have up to 65 unit fields with 70 to 100 zones.. > > Currently i have a autopk field. but I'm not sure if it will scale.. If i > have 5000 users and every users makes 100 quotations.. (7000 rows on the > worst case) this is 3500000000.. easy enought to get out of autoincrement > fields.. > > I'm thinking on getting rid of the pk field, and use a unique together > with (zone_units). do you think this is a good aproach with the orm? I saw > that is not possible to make primary key fields ( with grouped fields), but > perhaps I can do it with instead of declaring a int field, have a char > field storing the > %s_%s_%s ( quote_id, zone_id, units ) ... > > do you think the last could be a good aproach? > > Sure if i have to shard the data (on the future) I can do it, using this > kind of keys.. Data will be queryed by zone.. (For making comparasions of > quotes) > > I will apreciate any help on the matter. > > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/c2a69c66-d1b8-4f08-95ed-b26fbb1d762e%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/c2a69c66-d1b8-4f08-95ed-b26fbb1d762e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAD4ANxW3K2eA1pQ2L%3DZ3kJyooTjhpL1t6OzFF0r7KSY8Rvz5bQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
