[sweede]

Originally Posted by HolyKiller

I'm using this MOD on my forum, but if user use a LOT of [item] tags (one of my user wrote a nice Druid guide and use 33 tags in one post), the page get loading TOOOO SLOOOOOOOOW (more than 30sec).

What's wrong? I thing, if the items are cached in my DB, the mod should never connect to wowhead again due to collecting information about items, right? Because they are already cached in DB.

BTW: After 14 days my item_cache table have about 12MB

Forum is hosted on professional hosting company with excelent servers. Database is really fast and some friend using the same hosting for so HUGE database with HIGH BW and the don't have problems like i have.


So, any ideas what's wrong?

OR

Is there any way to integrate some function for LIMINT numbers of [item] TAGs in one post?


Thanks a lot for help

Holy

I've explained in this thread what happens.

when you first make a post with an item that hasnt been seen before, the product will have to hit wowhead.com for each item and the new item info (mainly the itemid).

After which, it performs a rather quick and light query to get the itemid.

typically, the post with an item that isnt seen yet will take a few seconds longer because of the wowhead query (which i need to capture and gracefully exit in case of a timeout).

After which, responses will be far faster.

For example this page.
http://underthemain.net/forums/showthread.php?t=12

No items in the table and the initial post
* Page Generation 1.21796 seconds
* Memory Usage 5,730KB
* Queries Executed 145 (?)

going back to the main forums then clicking on the post i just made.
* Page Generation 0.51620 seconds
* Memory Usage 5,032KB
* Queries Executed 11 (?)


When vbulletin updates the post cache, it re-queries the database for the items but it wont (shouldnt) hit wowhead.com again, since the only thing i need is the itemID.

One thing that it does do though that I will have to remove, is that it also gets the translations from wowhead.com