Hello, I was wondering about instance based management. If I'm wrong, please tell me.
When we have users and user generated content in a large database, query times are increased significantly. Why is there no instance based manager (like the models.Manager()) that basically generates a table for each user and queries ONLY that table? Would that not just flatten the database instead of increasing it's size? For example, if we have 1,000,000 users all of which generate at least 10 posts per day and one of the users only generates 5 in the span of 10 days, unless we have a many to many field or something to hold those five posts, the query time to find their posts would be ridiculous. So if we have a table generated for each user that holds arbitrary connections to anything they generate, it would in theory cut query times significantly. Why is there no feature like this? Again, if I'm wrong please tell me but the amount of tables doesn't matter and instead the data they hold does so, in my understanding, 1,000,000,000 posts will always be the size of 1,000,000,000 posts no matter their organization. I've got ideas on implementation and even asyncronous supports as well as customization but I have no idea how to bring this up to the django developers and I'm not even sure it would work (though, no matter how hard I try, I can't see anything wrong with it). Let me know your input and if there's a way I can ask the django devs about this and possibly even suggest a few things pertaining to it. I'd like to help make django the best it can be and if this works and we can implement it, django will be very fast with user generated content. -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-developers+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/7e36ded7-2f3d-43c2-881c-cbc75c80b5c2n%40googlegroups.com.
