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.

A bookmark along the lines of

[code]
http://www.mersenne.org/manual_result/?user_login=FOOO&user_password=BAAR&B1=GO
[/code]should save your day. :geek:

[QUOTE=bcp19;292438]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.[/QUOTE]

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?

[QUOTE=chalsall;292440]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?[/QUOTE]

At first thought, maybe because Primenet has many many more records it deals with?

[QUOTE=bcp19;292442]At first thought, maybe because Primenet has many many more records it deals with?[/QUOTE]

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....

[QUOTE=chalsall;292440]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?[/QUOTE]

Because PrimeNet runs on Microsoft SQLServer? :smile:

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

Luigi

[QUOTE=ET_;292448]Being serious now, I think Primenet has many many more tables to join for each query.[/QUOTE]

It shouldn't take a rocket scientist to figure out that a multi-join query is going to take a really long time....

[QUOTE=ckdo;292439]A bookmark along the lines of

[code]
http://www.mersenne.org/manual_result/?user_login=FOOO&user_password=BAAR&B1=GO
[/code]should save your day. :geek:[/QUOTE]

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[/CODE]
Is there some way to work around this?

[QUOTE=kladner;292453]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[/CODE]

Is there some way to work around this?[/QUOTE]

It logs you on in almost no time, expand the manual testing and click results. No different from regular login except for time.

[QUOTE=bcp19;292454]It logs you on in almost no time, expand the manual testing and click results. No different from regular login except for time.[/QUOTE]

By golly, you're right! Thanks!

[QUOTE=kladner;292453]I've been trying to make this work
<snip>
Is there some way to work around this?[/QUOTE]

Use login.php

[CODE]http://www.mersenne.org/login.php?user_login=FOO&user_password=BAR[/CODE]

EDIT:- Or Just

[CODE]http://www.mersenne.org/?user_login=FOO&user_password=BAR[/CODE]