| Author |
 Topic  |
|
|
sikandar
Junior Member
Pakistan
135 Posts |
 Posted - 05 April 2009 : 12:26:00
|
Hi,
It is strange that I did not change any thing on the forum but when I am trying to search with any text no result is displaying. What is the possible reason? thanks |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 06 April 2009 : 05:17:20
|
Link?
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 07 April 2009 : 00:46:07
|
| I tried searching on this site and got SQL Server Timeout errors. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 07 April 2009 : 01:47:15
|
quote:
Originally posted by Astralis
I tried searching on this site and got SQL Server Timeout errors.
narrow your search criteria to a specific forum or try /forum/search2.asp and search a specific category, and don't hijack someone elses topic in future. |
|
|
|
bud_dadude
Starting Member
Australia
21 Posts |
Posted - 12 April 2009 : 22:05:32
|
Hey guys,
I have modded a modded search page that someone else did to fix the timeout issue. You can grab a copy from here -
http://mrtwo.mine.nu/search.txt
I just added a connection timeout value for the connection to the database |
Edited by - bud_dadude on 12 April 2009 22:06:26 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 April 2009 : 02:31:27
|
that isn't realy a solution, by increasing the timeout value can actually cause more problems than you solve.
There are modded search pages that have been optimised for specific databases (it is the generic nature of the search code which causes the tiemouts) |
|
|
|
KC
Junior Member
USA
152 Posts |
Posted - 13 April 2009 : 12:39:21
|
quote:
Originally posted by HuwR
that isn't really a solution, by increasing the timeout value can actually cause more problems than you solve.
Indeed.
On a site this size someone searching for "e" in all forums, entire post, would take a week to process and drop the server to it's knees while it tried.
|
 Owner of vales.com and Elite Computers. |
|
|
|
bud_dadude
Starting Member
Australia
21 Posts |
Posted - 14 April 2009 : 22:58:14
|
quote:
Originally posted by HuwR
that isn't realy a solution, by increasing the timeout value can actually cause more problems than you solve.
There are modded search pages that have been optimised for specific databases (it is the generic nature of the search code which causes the tiemouts)
It works for me. Why it doesn't work properly in the base code is the question to ask. Surely this is essential functionality!
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 April 2009 : 09:46:37
|
| it doesn't work in the base code because the base code uses generic SQL that works in Access/MySQL and MSSQL that is what is ESSENTIAL for the base code, if you want something more efficient and tailored to a particular flavour of SQL then that is what the MODS are targeted at. |
|
|
| |
Topic |
|
Topic Locked
