Print

[giorgio79]

Hello,

I was just checking out the buddy table structure, and as I understand, there is a new row for every connection...

Would this slow down querying for a larger site with thousand of users, and tens of thousands of connections?

What do you think? Any experience with this?

Thanks,

Gyuri

[Stramm]

There's an index on the user id... so the search for all buddies of a certain user is pretty fast. A search for only one id of course would be faster. However with the actual system further preparation of the data is not necessary. No preg_match or ereg, no sorting of arrays, no joining data together to a string etc. I have a database to let do it the database stuff.

Of course you can rewrite the code and do the necessary data preparation. If it works fast and stable it's no problem to replace the existing code with yours.

[giorgio79]

Cheers Stramm!

Thanks for the kind explanation.

I broke up my questions on this topic to two threads to meet the one question per topic Hope this was OK.

I was checking out the code and there are only a few queries on the buddy table so I might rewrite those select statements as I have a networking site with a member table that has ids stored for a member in one field

[giorgio79]

Stramm, just one more question. if I would rewrite some of these queries, can I use the API for the Modpack as well?

I have read that it is not a good idea to change the core code...

Cheers,

Gyuri

[Stramm]

Honestly, I do not know cause I never used the api... just try. But nothing would come to my mind that'll stop it from working