Well, soon at least. :)
Rofl!
Classic.
He just cracked 75. =p
Thats amazing!
wow, iago pumps out his posts! :D
Yea... it doesn't take him 10 minutes to a load a page like the rest of us. LAN cheat T_T
If you look at the bottom, the majority of the time (for long loads) is the SQL Querying. So, in fact, it takes me nearly the same time :P
Your sql sever is slow. :P
Quote from: Blaze on December 11, 2005, 11:04:18 AM
Your sql sever is slow. :P
QuotePage created in 3.652 seconds with 25 queries.
That's not bad considering the number of things his database has in it.
iago, I'm curious. How big is the SMF database for these forums? :)
Page created in 5.236 seconds with 23 queries.
T.T
Page created in 6.986 seconds with 24 queries.
:)
In case anyone else is interested:
Quote
Ron says:
almost 6mb
Ron says:
zipped
Chris M. says:
Heesh
Ron says:
21mb unzippped
Yeah, the DB is pretty big. I wonder if eliminating all old posts would help, but I don't wanna.
One day I'll buy a better computer, and migrade the DB to that.
Quote from: iago on December 11, 2005, 01:46:34 PM
Yeah, the DB is pretty big. I wonder if eliminating all old posts would help, but I don't wanna.
One day I'll buy a better computer, and migrade the DB to that.
Hmm... I'm curious as to how my server would run a database this big. Would you mind zipping it up and sending it to me? :]
Quote from: Sidoh on December 11, 2005, 02:07:47 PM
Quote from: iago on December 11, 2005, 01:46:34 PM
Yeah, the DB is pretty big. I wonder if eliminating all old posts would help, but I don't wanna.
One day I'll buy a better computer, and migrade the DB to that.
Hmm... I'm curious as to how my server would run a database this big. Would you mind zipping it up and sending it to me? :]
LOL! Not gonna happen. ;)
Quote from: Blaze on December 11, 2005, 02:31:33 PM
LOL! Not gonna happen. ;)
Why? Passwords are hashed.
It contains PMs and private board (leaders), though.. although I trust you, I don't think it's very appropriate.. :/
Quote from: iago on December 11, 2005, 02:49:39 PM
It contains PMs and private board (leaders), though.. although I trust you, I don't think it's very appropriate.. :/
Oh yeah, haha. Remove them! :)
Haha, it was more of a curiosity; it's more trouble than it's worth. :)
Yeah, exactly :P
And I'm sure it'll perform better than darkside, which is 433mhz/256mb ram :)
Quote from: iago on December 11, 2005, 03:33:00 PM
Yeah, exactly :P
And I'm sure it'll perform better than darkside, which is 433mhz/256mb ram :)
Meep! I'm going to buy you a stick of RAM for Christmas!
Quote from: iago on December 11, 2005, 03:33:00 PM
Yeah, exactly :P
And I'm sure it'll perform better than darkside, which is 433mhz/256mb ram :)
Yikes, you really need an upgrade.
Quote from: Topaz on December 11, 2005, 03:38:29 PM
Quote from: iago on December 11, 2005, 03:33:00 PM
Yeah, exactly :P
And I'm sure it'll perform better than darkside, which is 433mhz/256mb ram :)
Yikes, you really need an upgrade.
The only thing that doesn't run perfectly is a 20mb database. Besides that, there's absolutely nothing wrong with it.
Quote from: iago on December 11, 2005, 03:39:16 PM
The only thing that doesn't run perfectly is a 20mb database. Besides that, there's absolutely nothing wrong with it.
Hehe.
Sidoh, it would be simple to write a script that makes a large database for you, if you are that interested. Probably wouldn't take all that long.
Quote from: Quik on December 11, 2005, 04:55:16 PM
Sidoh, it would be simple to write a script that makes a large database for you, if you are that interested. Probably wouldn't take all that long.
But it wouldn't have the variability that a "used" forum database would have. It was just a mild curiosity, no big deal.
Quote from: Sidoh on December 11, 2005, 03:47:33 PM
Quote from: iago on December 11, 2005, 03:39:16 PM
The only thing that doesn't run perfectly is a 20mb database. Besides that, there's absolutely nothing wrong with it.
Hehe.
Let me take this oportunity to stick in a nice
I told you so Sidoh!
Quote from: Joe[e2] on December 12, 2005, 06:50:21 AM
Let me take this oportunity to stick in a nice I told you so Sidoh!
Actually Joe, I'd never,
never not upgrade that. I stand by my stance. That computer sucks and I'd never use it as a server. It'd crap out for all the shit I use it for.
Maybe I'll stick in a nice
STFU Joe here. :P
If you aren't running Windows, the power of a system takes on a whole new meaning. You'd be surprised at how much can be done on a 433mhz box.
Quote from: iago on December 12, 2005, 11:27:59 AM
If you aren't running Windows, the power of a system takes on a whole new meaning.
Heh, so true. :)
Give the database away for christmas presents.
For the record, the SMF delay is much lesser on other forums:
QuotePage created in 0.274 seconds with 11 queries.
QuotePage created in 0.403 seconds with 16 queries.
QuotePage created in 0.392 seconds with 11 queries.
G_G
Also, I would just like to say that Ron is a forum whore.
Quote from: MyndFyrex86] link=topic=4059.msg44424#msg44424 date=1134430899]
For the record, the SMF delay is much lesser on other forums:
QuotePage created in 0.274 seconds with 11 queries.
QuotePage created in 0.403 seconds with 16 queries.
QuotePage created in 0.392 seconds with 11 queries.
G_G
Also, I would just like to say that Ron is a forum whore.
quoted and /signed for truth.
Quote from: MyndFyrex86] link=topic=4059.msg44424#msg44424 date=1134430899]
For the record, the SMF delay is much lesser on other forums:
QuotePage created in 0.274 seconds with 11 queries.
QuotePage created in 0.403 seconds with 16 queries.
QuotePage created in 0.392 seconds with 11 queries.
G_G
Also, I would just like to say that Ron is a forum whore.
Yeah, processing a large database does hurt the CPU.
iago you gotta stop posting here, seriously dude i'm worried about you, just put the keyboard down, we'll get you some professional help man. :D
Quote from: iago on December 12, 2005, 11:27:59 AM
If you aren't running Windows, the power of a system takes on a whole new meaning. You'd be surprised at how much can be done on a 433mhz box.
You can do more faster if it's a better machine. :)
Quote from: GameSnake on December 12, 2005, 08:08:16 PM
iago you gotta stop posting here, seriously dude i'm worried about you, just put the keyboard down, we'll get you some professional help man. :D
I have to mark 111 similar looking assignments this week. Every 5 or so I hop over here to see what's happened. It's a job, I can't put the keyboard down.
(http://www.javaop.com/~iago/79.png)
Working on 105, out of 111. So close... I can't wait to finish this, so I can start studying for my exam (which is on Wednesday morning)!
Quote from: GameSnake on December 12, 2005, 08:08:16 PM
iago you gotta stop posting here, seriously dude i'm worried about you, just put the keyboard down, we'll get you some professional help man. :D
Just because you can't have a job that allows you to hold a keyboard in your hands all day... :P
Done!!
AFK for the night. :)
iago is a hacker! ::)
Yeah, no mortal being could have made it to 5412 in just that little time.. =p
You forget that iago spends time here while he's "working."
Quote from: deadly7 on December 19, 2005, 10:36:47 PM
You forget that iago spends time here while he's "working."
Yeah, and iago isn't fat, he's jolly!
LOL