Re: Django ManyToMany performance?

Thanks Daniel and Robin.

Have we seen the scales where Many-to-many DBs through Django work well? Like 50K articles in 5K publications. 

The aim of this question was to make a design choice too - whether I should use Django constructs/calls directly or should i write my own SQL to make queries - as my schemas are not just many-to-many but a lot more than that. 

Thanks for the suggestion on getting the DB schemas reviewed by a DB expert. I realized that is going to help me a lot for sure!

On Mon, Oct 28, 2013 at 1:40 AM, Robin St.Clair <robinstc@live.co.uk> wrote:

First of all , any DBMS that is misused by design or in operation will give poor performance.. There is an excellent mature database available for Django developers, PostgreSQL. It works fine on the same machine as you are developing on.

MongoDB is NOT a suitable DB for general purposes. It is fine for documents, less good for being updated, particularly as it locks tables when updating or inserting.

Make sure your generated database is checked by somebody who knows about databases.

R+C

--
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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/6007019b-b007-4d46-adab-4dcbf16b0e7d%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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/CAEGxL4nfAUJJ210T7XCL%2BHOOSijr0wY9Ya3p%2BGNLBaU%3DfDDSDQ%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.