SMF Support > Server Performance and Configuration

Slow searchs

(1/3) > >>

minskog:
I migrate a big forum from phpbb and all ok but the searchs.

The forum have more than 830.000 posts, 27.000 threads and 3.000 users. When i make one search the cpu goes to 100% and need over 50/60 seconds to show the results. Anyone knows how to fix it?

Ben_S:
SMF 1.1 has greatly improved search performance, untill that comes out though I guess you are kind of stuck :-\.

Enigma:
just out of curiousity, what are the specs of the coputer that hosts your forum?

minskog:
Pentium 4 2.8 HT, 1 gb ram ecc, hd sata. Load average 0.35  ::)

[Unknown]:
Have you converted any of the tables - notably, such as log_search - to InnoDB?

-[Unknown]

Navigation

[0] Message Index

[#] Next page