Bug You dont index your tables and that REALLY causes problems :)

[Regitze Birketoft]

hey there

as you know i have a relatively large forum, and after installing your product i got some SERIOUS troubles with "go advanced" and posting... they got slow - up to 45+ secs and posting often timed out

i have located the reason - you dont create indexes on your tables... when creating all the counters it does it without indexing and thats a bitch!!

I have fixed it locally - but you really need to fix this cause it should be done via your product

My users love the mod and now when everything is fixed it's great - but please - indexes so you dont overload the DB's

 

[Fillip H.]

Can you tell me exactly what columns you have indexed, then?

 

[Regitze Birketoft]

i indexed contentid, userid, contenttype in regard to your product

that solved the problem in my end

 

[Fillip H.]

I've identified a problem where sometimes it would fail to create the index if duplicate entries had been inserted into the database. The index has actually been in place since v1.1.0, but a bug affecting previous versions allowed duplicate entries, which caused the "add unique index" statement to fail.

This will be corrected in the next version.