Author |
Topic |
Jarrek
Starting Member
3 Posts |
Posted - 2005-02-02 : 23:13:51
|
Which is this site and forum.Just wondering what hardware it runs on (CPU, Memory, etc) ?I assume it's on an SQL backend.Love it. |
|
Jarrek
Starting Member
3 Posts |
Posted - 2005-02-02 : 23:14:51
|
Ok, that was until I POSTED this message. Browsing is fast, posting ... urm ...This page was generated in 20.45 seconds. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-03 : 03:51:06
|
testrockmoose |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-03 : 03:51:47
|
0.26 secondsrockmoose |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-03 : 04:53:30
|
moose haven't you learned yet not to use test anymore.... you're just asking for it (Super Kristen Attack) Go with the flow & have fun! Else fight the flow |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-02-03 : 07:16:57
|
if you're going to do that it should be more like:[while waving wand]Increase Post Count![/while waving wand]EDIT: 20.5 seconds (though that is not the norm for me )Corey"If the only tool you have is a hammer, the whole world looks like a nail." - Mark Twain |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-03 : 10:47:45
|
rockmooseAged Yak WarriorSweden974 Posts74 Relevant postsI feel so ashamed now Edit: This page was generated in 0.23 secondsStill the fastest forum I've been to except for the searching aaawwwhg... |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-02-03 : 12:22:26
|
I've added a number of indexes to increase query performance. Those also slow down inserts but shouldn't make it 20 seconds. We're running on a shared SQL Server so I'm guessing it's somebody else's poor queries. I haven't looked at overall performance in a while. I may have to again at some point.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-03 : 12:29:50
|
Usually the inserts are ok but occasionally they hang and take a bit of time.Like that one took 20.61 secs.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
Jarrek
Starting Member
3 Posts |
Posted - 2005-02-03 : 13:38:38
|
So what are the server specs ? |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-02-03 : 14:40:04
|
No idea. It's hosted at www.orcsweb.com on one of their shared servers. Great company. Great hosting.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|