| Author |
Topic |
|
scullee
Posting Yak Master
103 Posts |
 Posted - 2003-04-22 : 19:38:35
|
| The search screen takes a very long time to load over my internet connection.Just out of curiosity i had a look at the size of the page and it seems to be coming in at a whopping 300+k every time it is loaded. The main culprit i see is the list of members that come down every time.Is there another way i can do a search without having load such a big page? |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-22 : 19:58:20
|
| How will you reduce the amount of data comming through?3 ways that I can seeA. Redesign interface to have more screens and each screen narrows your search space. In your case maybe have user select a letter or set of letter from a drop down and have your jscript talk to a hidden frame that communicates with the database via cgi (asp/jsp) and seamlessly updates the drop down.B. Preload your data into a hidden frame one time at the start of a session and/or try to cache the data and/or try to have the data as a static js include if it doesn't change frequently.C. Reduce amount of HTML by returning raw data and having JS dynamically populate drop down list.Alternatively allow free text input and have some high end search logic that suggests alternatives in case of mispellings of names. |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-04-22 : 20:07:43
|
I think the newer versions of snitz do away with that huge drop list. I believe that upgrading snitz is a bit of a pain though, so it keeps slipping down Graz's todo list.It will happen  Damian |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-22 : 21:59:12
|
| Frankly, an easy way to trim that list is to delete the couple thousand orphaned users...people who haven't logged on in over a year and never posted anything. There are A TON like this. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-04-23 : 07:28:40
|
quote:
Frankly, an easy way to trim that list is to delete the couple thousand orphaned users...people who haven't logged on in over a year and never posted anything. There are A TON like this.
Interesting. Or I could just modify the SELECT statement that populates the list box to remove everyone that hasn't posted in the last six months. :) I'll take a look at that next week.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
RatTail
Crackhead
98 Posts |
Posted - 2003-04-23 : 11:20:51
|
| i know the best and ultimate way but i'm afraid to 'reveal' it... |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-04-23 : 11:35:08
|
quote:
i know the best and ultimate way but i'm afraid to 'reveal' it...
Hmmm ... how aboutDELETE FROM users WHERE HelpFul_Post_Count < Weird_Posts_No_One_Understands_Count- Jeff |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-04-23 : 11:42:41
|
Jeff, I LOVE it. I'll go run that now  Damian |
|
|
|
RatTail
Crackhead
98 Posts |
Posted - 2003-04-23 : 12:07:08
|
| OK guys! Just only once save the 'search.asp' page as htm file on your local hard drive.Then open this htm file in Notepad, find in its HTML code two occurences ofword 'action' and insert right after 'action=' full path to target page, i.e.replace 'action=/Forums/search.asp' with'action=http://www.sqlteam.com/Forums/search.asp'.Now you may open this htm file in your browser (even off line), fill its fields and(after connecting) push the 'Search' button. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-04-23 : 12:20:47
|
| That's actually not too bad, Rattail ... Seeing as how to search page is relatively static, it should work fine. Of course, new members that joined since you saved the search.asp as HTML will not show up on the drop down unless you re-save the HTML from the source again.- Jeff |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-04-23 : 13:10:42
|
quote:
OK guys! Just only once save the 'search.asp' page as htm file on your local hard drive.Then open this htm file in Notepad, find in its HTML code two occurences ofword 'action' and insert right after 'action=' full path to target page, i.e.replace 'action=/Forums/search.asp' with'action=http://www.sqlteam.com/Forums/search.asp'.Now you may open this htm file in your browser (even off line), fill its fields and(after connecting) push the 'Search' button.
There's nothing like solving symptoms!===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-04-23 : 13:51:04
|
| I’d be interested in seeing the S.P. behind that Search.Jim |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-04-23 : 14:58:14
|
quote:
I’d be interested in seeing the S.P. behind that Search.Jim
Stored Procedure? Sorry, it's straight SQL dynamically built at the client. And boy is it slow. If you click on the Snitz link at the bottom of the forum you can download a copy of the forums.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-06-13 : 19:30:27
|
| And this is "fixed". Or at least the problems mitigated. You can now only search for posts by members that have posted since the start of the year. That dropped the page size from 400K to 70K. Hopefully that's enough until I can upgrade the forums.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-13 : 21:09:16
|
| FYI - I've added some further tweaks to improve performance and reduce the amount of HTML returned. No offense to any Snitz programmers who might be reading this, but come on guys! There's no point in added spaces just to make the HTML nicely formatted!Removing those spaces alone cut a 70K page down to 60K. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-17 : 09:14:48
|
quote:
There's no point in added spaces just to make the HTML nicely formatted!
Is that like having an IDENTITY column to make sure you have a unique "key"....Sorry...it just lept off my finger tips...Brett8-) |
|
|
|
|
Search Screen Speed