mersenneforum.org Server usage on logging in
 Register FAQ Search Today's Posts Mark Forums Read

 2012-03-09, 18:24 #1 bcp19     Oct 2011 7×97 Posts Server usage on logging in I've been thinking, a lot of time when I log in, I am looking to goto the manual submission page, and can end up waiting 2 minutes for the statistics page to be calculated and shown. Why not have it go to a generic "Thank you for logging in" page which should only take a few seconds, and then if someone actually wants to, then let them click the status page. I would think it would end up saving a lot of wear and tear on the server. Edit: Was just thinking, this should also save wear on the server for all the people using the submission spider, as the spider sends the data same as if you were visiting the page, and needs nothing more than login sucess, caring nothing for the stats. Last fiddled with by bcp19 on 2012-03-09 at 18:31
 2012-03-09, 18:31 #2 ckdo     Dec 2007 Cleves, Germany 2×5×53 Posts A bookmark along the lines of Code: http://www.mersenne.org/manual_result/?user_login=FOOO&user_password=BAAR&B1=GO should save your day.
2012-03-09, 18:46   #3
chalsall
If I May

"Chris Halsall"
Sep 2002

100100101110102 Posts

Quote:
 Originally Posted by bcp19 Edit: Was just thinking, this should also save wear on the server for all the people using the submission spider, as the spider sends the data same as if you were visiting the page, and needs nothing more than login sucess, caring nothing for the stats.
You raise an interesting point.

Why does PrimeNet often time-out when a user logs in?

I can run a query against my MySQL DB with 25 million records in about 1/10th of a second.

Why can't PrimeNet?

2012-03-09, 19:21   #4
bcp19

Oct 2011

7×97 Posts

Quote:
 Originally Posted by chalsall You raise an interesting point. Why does PrimeNet often time-out when a user logs in? I can run a query against my MySQL DB with 25 million records in about 1/10th of a second. Why can't PrimeNet?
At first thought, maybe because Primenet has many many more records it deals with?

2012-03-09, 19:41   #5
chalsall
If I May

"Chris Halsall"
Sep 2002

2×3×1,567 Posts

Quote:
 Originally Posted by bcp19 At first thought, maybe because Primenet has many many more records it deals with?
Or, perhaps, PrimeNet doesn't use Indexes properly?

Let's be honest here... The site needs to understand what are the most common requests, and optimize them.

Please note that both James' and my sites never take more than a second to render a page.

And we're all dealing with many millions of records....

2012-03-09, 19:52   #6
ET_
Banned

"Luigi"
Aug 2002
Team Italia

3×1,597 Posts

Quote:
 Originally Posted by chalsall You raise an interesting point. Why does PrimeNet often time-out when a user logs in? I can run a query against my MySQL DB with 25 million records in about 1/10th of a second. Why can't PrimeNet?
Because PrimeNet runs on Microsoft SQLServer?

Being serious now, I think Primenet has many many more tables to join for each query.

Luigi

Last fiddled with by ET_ on 2012-03-09 at 19:53

2012-03-09, 20:06   #7
chalsall
If I May

"Chris Halsall"
Sep 2002

2·3·1,567 Posts

Quote:
 Originally Posted by ET_ Being serious now, I think Primenet has many many more tables to join for each query.
It shouldn't take a rocket scientist to figure out that a multi-join query is going to take a really long time....

2012-03-09, 21:20   #8

"Kieren"
Jul 2011
In My Own Galaxy!

22×43×59 Posts

Quote:
 Originally Posted by ckdo A bookmark along the lines of Code: http://www.mersenne.org/manual_result/?user_login=FOOO&user_password=BAAR&B1=GO should save your day.
I've been trying to make this work, replacing FOOO and BAAR with [username] and [password]. It goes to the manual results page, but acts as if Upload has been clicked, with no input. That is, it comes up saying:
Code:
No factor lines found: 0
Mfaktc no factor lines found: 0
Mfakto no factor lines found: 0
Factors found: 0
P-1 lines found: 0
LL lines found: 0
Mlucas lines found: 0
Glucas (G29) lines found: 0
Glucas lines found: 0
MacLucasFFTW lines found: 0
CUDALucas lines found: 0
ECM lines found: 0
Is there some way to work around this?

Last fiddled with by kladner on 2012-03-09 at 21:21

2012-03-09, 21:22   #9
bcp19

Oct 2011

7·97 Posts

Quote:
 Originally Posted by kladner I've been trying to make this work, replacing FOOO and BAAR with [username] and [password]. It goes to the manual results page, but acts as if Upload has been clicked, with no input. That is, it comes up saying: Code: No factor lines found: 0 Mfaktc no factor lines found: 0 Mfakto no factor lines found: 0 Factors found: 0 P-1 lines found: 0 LL lines found: 0 Mlucas lines found: 0 Glucas (G29) lines found: 0 Glucas lines found: 0 MacLucasFFTW lines found: 0 CUDALucas lines found: 0 ECM lines found: 0 Is there some way to work around this?
It logs you on in almost no time, expand the manual testing and click results. No different from regular login except for time.

2012-03-09, 21:25   #10

"Kieren"
Jul 2011
In My Own Galaxy!

22·43·59 Posts

Quote:
 Originally Posted by bcp19 It logs you on in almost no time, expand the manual testing and click results. No different from regular login except for time.
By golly, you're right! Thanks!

2012-03-09, 21:27   #11
axn

Jun 2003

2·32·269 Posts

Quote:
 Originally Posted by kladner I've been trying to make this work Is there some way to work around this?

Code:
http://www.mersenne.org/login.php?user_login=FOO&user_password=BAR
EDIT:- Or Just

Code:
http://www.mersenne.org/?user_login=FOO&user_password=BAR

Last fiddled with by axn on 2012-03-09 at 21:29

 Similar Threads Thread Thread Starter Forum Replies Last Post daxmick GPU Computing 3 2018-01-18 01:16 mes4646 Information & Answers 21 2015-10-30 10:00 Xyzzy Linux 10 2015-09-25 17:55 Brian-E Forum Feedback 3 2007-12-14 13:18 Xyzzy Software 7 2002-09-26 18:56

All times are UTC. The time now is 09:44.

Tue Jan 19 09:44:38 UTC 2021 up 47 days, 5:55, 0 users, load averages: 1.19, 1.62, 2.00