Hello @LL,
first of all i want to comment on the last info and then i will give a general update about this hack.
@KirbyDE: I know this hack already and this hack is only for phpBB and i tried to convert it to vb and i failed. It is much more then just an adjustment. It is fully integrated into phpBB. In addition i do not think that it is much more powerful. The official version does not have the features you are mentioning. Only the development link you just posted have these features and it is not finished yet. It still has bugs in it. Regardless of this i want to add this for all people here.
@ALL: I just installed this hack on a board with over 10000 users and my hack failed miserably. The performance was reduced due to my SQL loads and the complete server stopped for about 1 minute every SQL request. This is UNACCEPTABLE. I had to remove the hack immediately.
As it looks like this hack works fine for small communities but not for large boards.
2 options now:
1) discontinue the hack completly
2) start from scratch with a complete new system/concept
The OpenGeoDB is not optimized for so many SQL queries. It is for finding one specific location + nearest locations and nothing else.
Sorry for that but i do either create an overall good working hack or none but nothing between.
Cheers,
|