On May 14, 2015, at 10:30 PM, Me Sulphur <[email protected]> wrote: > > * It is a large key-value pair table (approaching ~ 1 bn rows) with an MD5 > key and JSON for value. The look ups depend on the business logic but are > necessary. Nevertheless, there are no more than 10-12 queries executed by > combining key look ups using WHERE IN queries and pg is surprisingly good > with IN queries.
If this is the case, then I strongly recommend switching to a NoSQL DB. You aren’t using any of the Django ORM functionality, so there’s no need to switch to django-nonrel. Almost all of them are faster at key/value returns than PostgreSQL. Peter of the Norse [email protected] -- 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/794491DD-ADB8-422A-AE03-0D4D8546E4E2%40Radio1190.org. For more options, visit https://groups.google.com/d/optout.
