| Author |
Topic |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
 Posted - 2005-01-27 : 18:04:23
|
| Since I'm home sick today and bored out of my skull so I made a few changes to the forum search. Some of the SQL it was generating wasn't as optimized as it could have been.I also removed the option to search for any of the words. That seems to be slow no matter what I do to the query.I also limited it to just the top 100 results. If you need more than that you'll have to refine your search terms.It should time out less now. It's by no means fast -- but it is usable. Let me know how it works for you.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-27 : 18:07:00
|
| and there was much rejoicing amongst the people.Damian |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-01-27 : 19:56:35
|
| Wow, it works!A search for "disk performance" returned in 14.1 seconds!Well done Gratz, hope ya feel better!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-29 : 00:28:58
|
Graz, next time you're sick and bored, hop across the way.  I always have some work you can do if you're bored. Hope you're feeling better.Merkin, if you only knew how much rejoicing I do now.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-02-01 : 17:15:20
|
| Well I went to look for SQL Alpine Team...And it couldn't find it...I swear that was the title....any ideas?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-02-01 : 17:29:15
|
Yes, sorry the performance overhead of a Brett translator was just too much for the server to handle.damn users! Damian |
|
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2005-02-01 : 17:31:30
|
| "Fascinating" - Mr. Spock~~~~~~~~~~~~~Semper fi, Xerxes, USMC |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2005-02-01 : 17:50:22
|
Also a search for the word margarita brings the server to its knees...  |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-02-02 : 09:34:50
|
quote:
Originally posted by Merkin
Yes, sorry the performance overhead of a Brett translator was just too much for the server to handle.damn users!Damian
What a maroon What, no fuzzy searches?Brett8-) |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-02-02 : 20:58:21
|
quote:
Originally posted by ehorn
Also a search for the word margarita brings the server to its knees...
As it usually does me ...===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
The joys of searching the forum