Re: Select Table or Database based on User

2009-08-06 Thread Wojciech Gryc
Hi everyone, All right, you have convinced me. I'll implement this way. Thank you all for the advice and help! - Wojciech On Aug 6, 7:30 am, Daniel Roseman wrote: > On Aug 5, 11:38 pm,WojciechGryc wrote: > > > Thanks for your replies! > > > The problem with storing the user ID for each table

Re: Select Table or Database based on User

2009-08-05 Thread Daniel Roseman
On Aug 5, 11:38 pm, Wojciech Gryc wrote: > Thanks for your replies! > > The problem with storing the user ID for each table and then filtering > by the ID is that once the data set grows very large, this will become > extremely slow (as far as I understand). > > I expected to have about 2000 piec

Re: Select Table or Database based on User

2009-08-05 Thread Javier Guerra
Wojciech Gryc wrote: > Filtering by user ID each time would > be extremely wasteful, would it not? not with the right indexes. -- Javier --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To pos

Re: Select Table or Database based on User

2009-08-05 Thread Maksymus007
On Thu, Aug 6, 2009 at 12:38 AM, Wojciech Gryc wrote: > > Thanks for your replies! > > The problem with storing the user ID for each table and then filtering > by the ID is that once the data set grows very large, this will become > extremely slow (as far as I understand). > > I expected to have a

Re: Select Table or Database based on User

2009-08-05 Thread Wojciech Gryc
Thanks for your replies! The problem with storing the user ID for each table and then filtering by the ID is that once the data set grows very large, this will become extremely slow (as far as I understand). I expected to have about 2000 pieces of information per user, with several dozen users (

Re: Select Table or Database based on User

2009-08-05 Thread Paulo Almeida
Yeah, the way I do that is have a foreign key with the user in the table with private data and then filter by user when retrieving data in the view. On Wed, Aug 5, 2009 at 10:11 PM, Maksymus007 wrote: > > > > > Hi everyone, > > > > I'm sure this has come up in the past, but I sincerely can't fin

Re: Select Table or Database based on User

2009-08-05 Thread Maksymus007
> > Hi everyone, > > I'm sure this has come up in the past, but I sincerely can't find it > in any of the Django tutorials, documentation, or websites. I > apologize in advance if I missed something! > > I'm trying to develop a website where different users store their own > sets of contacts / art

Select Table or Database based on User

2009-08-05 Thread Wojciech Gryc
Hi everyone, I'm sure this has come up in the past, but I sincerely can't find it in any of the Django tutorials, documentation, or websites. I apologize in advance if I missed something! I'm trying to develop a website where different users store their own sets of contacts / articles / etc. If