Tribalwar Admin Contributor
|
I understand but its a lot easier for me just to make a script although its fun to think about this I guess.
|
|
|
VeteranX
|
Yeah, I know. You have to create it. Give it a single column called "ID." Then insert rows for 1-400 into it.
|
|
|
VeteranXV
|
Quote:
Originally Posted by Rayn
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.
|
|
|
VeteranX
|
Quote:
Originally Posted by Rayn
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.
|
|
|
VeteranXV
|
Quote:
Originally Posted by -raven-
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...
|
|
|
VeteranX
|
Quote:
Originally Posted by Gil
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.
|
|
|
VeteranX
|
Quote:
Originally Posted by Gil
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.
|
|
|
VeteranXV
|
Quote:
Originally Posted by -raven-
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.
|
|
|
Tribalwar Admin Contributor
|
Quote:
Originally Posted by -raven-
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.
|
|
|
VeteranXV
|
Quote:
Originally Posted by -raven-
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.
|
|
|
VeteranXX Contributor
|
who got it
|
|
|
VeteranXX
|
Quote:
Originally Posted by Fancy Cat
who got it
|
absent, SIG HEIL
|
|
|
VeteranXX Contributor
|
haha
|
|
|
VeteranX
|
Quote:
Originally Posted by Rayn
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.
|
|
|
VeteranXX
|
Quote:
Originally Posted by samUwell
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.
|
|
|
VeteranXX
|
Quote:
Originally Posted by -raven-
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.
|
|
|
VeteranXX
|
omy
|
|
|
VeteranXX Contributor
|
strangely I decided to ignore absent earlier today, which is rare for me
I guess it paid off
|
|
Last edited by aNimAL; 07-27-2008 at 03:48..
|
VeteranX
|
Hasn't Orbital consistently been the most ignored user on these forums for like the past 5 years?
|
|
|
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)
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
AGENT: claudebot / Y
All times are GMT -4. The time now is 12:09.
|