Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Sep 1999
Posts: 339
Kahuna
Kahuna
Offline
Joined: Sep 1999
Posts: 339
Ok, so I'm dealing with 300k records, so you won't notice the difference here.

BUT, on my db if I search for any word, all forums, 1 week, results are back in less than a second.

When I change to 2 weeks, it takes 12-20 seconds.

When I change to all posts, it takes the same amount of time as the 2 week search.

What's so special about posted newer than 1 week?


Muhammad
Sponsored Links
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
Which UBB.threads version?

An easy thing to do first is to figure out exactly what database query is used for the search, and then use EXPLAIN. E.g., EXPLAIN SELECT * FROM w3t_Posts WHERE (whatever). That will provide some information about how MySQL will do the query. Try it for a one-week query and a two-week query, and see if there's any difference in the EXPLAIN output.

Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
Maybe your MySQL hasn't enough memory so that it needs to swap if you search over a longer period.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)