[Pseudomizer]

Originally Posted by Reeve of shinra

Great hack but I saw it was using 71 queries... I dont know if that can be reduced but if not, you may want to limit how often the page can be refreshed (like the search feature) in case someone gets pissed at you and decides to reload that page until your site crashes.

Hi Reeve,

you are right. 71 queries are a lot and this is the reason why this is a BETA release. There is no performance tuning done, there is no optimization done yet. This is on the to-do list.

But regardless of this we can discuss this here because i see a problem how to reduce the number of queries. I need the ZIP code for each member. Then i need to draw the point into the map where this member lives and then i have to gather the information about this member like habition and link to his profile.

So in total there are 2 x times the number of members queries for this page. I reduced it already from 4 x times the number of members by using arrays but keep in mind that i have to draw a point into the map for each member.

But i am very open for suggestions to reduce the number of queries because i always try to keep my queries very low. Any ideas ?

Cheers,