I'm running a script to see who the most ignored user is ... by Rayn - Page 8 - TribalWar Forums
Click Here to find great hosting deals from Branzone.com


Go Back   TribalWar Forums > TribalWar Community > General Discussion
Reload this Page I'm running a script to see who the most ignored user is ...
Page 8 of 13
Thread Tools
Rayn
Tribalwar Admin
Contributor
Old
141 - 07-27-2008, 01:07
Reply With Quote
I understand but its a lot easier for me just to make a script although its fun to think about this I guess.
 
Rayn is offline
 
Sponsored Links
-raven-
VeteranX
Old
142 - 07-27-2008, 01:07
Reply With Quote
Yeah, I know. You have to create it. Give it a single column called "ID." Then insert rows for 1-400 into it.
 
-raven- is offline
 
Gil
VeteranXV
Old
143 - 07-27-2008, 01:08
Reply With Quote
Quote:
Originally Posted by Rayn View Post
I understand but its a lot easier for me just to make a script although its fun to think about this I guess.
I realized that you probably know your database a lot better than TrImp. I don't know why he has such a hardon for SQL.

I mean SQL is nifty and all, but you have to use the best tool for the job.
 
Gil is offline
 
-raven-
VeteranX
Old
144 - 07-27-2008, 01:09
Reply With Quote
Quote:
Originally Posted by Rayn View Post
I understand but its a lot easier for me just to make a script although its fun to think about this I guess.
If you can write something in all SQL without using cursors its generally much faster.

You can just save the query in a sproc and then next month you just come along and type EXEC sp_get_most_ignored_users and there it is.
 
-raven- is offline
 
Gil
VeteranXV
Old
145 - 07-27-2008, 01:10
Reply With Quote
Quote:
Originally Posted by -raven- View Post
If you can write something in all SQL without using cursors its generally much faster.

You can just save the query in a sproc and then next month you just come along and type EXEC sp_get_most_ignored_users and there it is.
or you could just write a view and save it, then call the view up once a month...
 
Gil is offline
 
-raven-
VeteranX
Old
146 - 07-27-2008, 01:11
Reply With Quote
Quote:
Originally Posted by Gil View Post
I realized that you probably know your database a lot better than TrImp. I don't know why he has such a hardon for SQL.

I mean SQL is nifty and all, but you have to use the best tool for the job.
It took his script over 20 minutes to run. There are only about (edit) 50,000 rows in this table (one for each user). Hardly the best tool for the job.
 
-raven- is offline
 
-raven-
VeteranX
Old
147 - 07-27-2008, 01:14
Reply With Quote
Quote:
Originally Posted by Gil View Post
or you could just write a view and save it, then call the view up once a month...
Sure. I just hesitate to put that kind of thing in a view since its computationally intensive... you dont want people writing queries against it without realizing what they are doing and calling on it all the time.
 
-raven- is offline
 
Gil
VeteranXV
Old
148 - 07-27-2008, 01:15
Reply With Quote
Quote:
Originally Posted by -raven- View Post
It took his script over 20 minutes to run. There are only about (edit) 50,000 rows in this table (one for each user). Hardly the best tool for the job.
maybe his priority was how easy/fast he could create it, not how efficient it would be?

don't think of this as a computer science problem. think of this as a business problem. he wants to maximize the use of his time and be as efficient as possible.


edit: this includes hyperventilating.
 
Gil is offline
 
Rayn
Tribalwar Admin
Contributor
Old
149 - 07-27-2008, 01:15
Reply With Quote
Quote:
Originally Posted by -raven- View Post
It took his script over 20 minutes to run. There are only about (edit) 50,000 rows in this table (one for each user). Hardly the best tool for the job.
the script runs in less than a second, I just had to find it.
 
Rayn is offline
 
Gil
VeteranXV
Old
150 - 07-27-2008, 01:16
Reply With Quote
Quote:
Originally Posted by -raven- View Post
Sure. I just hesitate to put that kind of thing in a view since its computationally intensive... you dont want people writing queries against it without realizing what they are doing and calling on it all the time.
mm, good point.
 
Gil is offline
 
Fancy Cat
VeteranXX
Contributor
Old
151 - 07-27-2008, 01:17
Reply With Quote
who got it
 
Fancy Cat is offline
 
Noumenon
VeteranXX
Old
152 - 07-27-2008, 01:18
Reply With Quote
Quote:
Originally Posted by Fancy Cat View Post
who got it
absent, SIG HEIL
 
Noumenon is offline
 
Fancy Cat
VeteranXX
Contributor
Old
153 - 07-27-2008, 01:19
Reply With Quote
haha
 
Fancy Cat is offline
 
-raven-
VeteranX
Old
154 - 07-27-2008, 01:19
Reply With Quote
Quote:
Originally Posted by Rayn View Post
the script runs in less than a second, I just had to find it.
Ok, that's a lot better.

I actually would have been pretty impressed if your script unintentionally took 20 minutes to run when its going against 50,000 rows and parsing up to 300 space separated values per row.
 
-raven- is offline
 
Zombie
VeteranXX
Old
155 - 07-27-2008, 01:41
Reply With Quote
Quote:
Originally Posted by samUwell View Post
thats straight pathetic.

especially coming from this forum.... one of the last places on the net where one can say what they want.

amazing!
The internet isn't a democracy.
 
Zombie is offline
 
Stilgar
VeteranXX
Old
156 - 07-27-2008, 01:44
Reply With Quote
Quote:
Originally Posted by -raven- View Post
It took his script over 20 minutes to run. There are only about (edit) 50,000 rows in this table (one for each user). Hardly the best tool for the job.
You're a tool, for what job...we don't know.
 
Stilgar is offline
 
SniperOmega
VeteranXX
Old
157 - 07-27-2008, 03:36
Reply With Quote
omy
 
SniperOmega is offline
 
aNimAL
VeteranXX
Contributor
Old
158 - 07-27-2008, 03:42
Reply With Quote
strangely I decided to ignore absent earlier today, which is rare for me

I guess it paid off
 
aNimAL is offline
 
Last edited by aNimAL; 07-27-2008 at 03:48..
alienkiller
VeteranXX
Old
159 - 07-27-2008, 03:49
Reply With Quote
rof
 
alienkiller is offline
 
Dumpy Dooby
VeteranX
Old
160 - 07-27-2008, 03:52
Reply With Quote
Hasn't Orbital consistently been the most ignored user on these forums for like the past 5 years?
 
Dumpy Dooby is offline
 
Page 8 of 13
Reply


Go Back   TribalWar Forums > TribalWar Community > General Discussion
Reload this Page I'm running a script to see who the most ignored user is ...

Social Website Bullshit

Tags
absent banned! , absent is jew , absent loves the jew dick , badmofo has a huge penis , ban absent , byebye absent , finland = jewland , for great justice , fuck tags , fuck yeah , fuck yeah tags , hey tags , jews > absent , keep tags permaban absent , motherfuckin tags , niggers jews bad news , shoot cops in face , suicide taxi is worthless , suicidetaxi is god , tags , tags > absent , tags are awesome , tags r back yo , tags! , turtles


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


AGENT: claudebot / Y
All times are GMT -4. The time now is 04:54.