I have an app which handles, lets say, Books. I'd like to display up to 1,000 of them on a single page. I don't really want to use pagination. However, this creates a little bit of a performance problem. Has anyone experienced such a situation and come up with a good setup?
A little more about my setup: - Books have Authors, Publishers, etc. I use select_related() instead of all(), but this does not improve performance much (half a second over about 6 seconds query time). - I use primary_key often instead of AutoId; could this create a performance issue? - MySQL and Apache are on different servers, but network is only 100Mb/ s. - Platforms are WinXP. - I user memcache/Win32, initial request is slow, subsequent requests are faster, albeit display is still slow (I use django admin templates to display my data). - Users need to login to access the site contents. - Each user can only see books which they have borrowed in the past or who's technical area is theirs. So there's an extra query to filter down the initial list of all books to the one they are actually authorized to see. Any help appreciated, JJ. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
