v5 alpha and beta testing game plan

[Batalov]

http://v5www.mersenne.org/results/
...this needs a bit of database query optimization. Several times I simply thought that this particular page doesn't work at all, but then decided to sit it out.... and after THREE (!!) minutes - voila -
____________________
Work Results Details
<user> has 11 results in the last 365 days

....<skipped>...

odbc_query_rows_array() 152125.65 ms 99.49%

odbc_fetch_row_column_array() 494.38 ms 0.32%
v5_start_odbc_tx() 162.42 ms 0.11%

.....

[S485122]

When a "Print simple text report" query includes bad results, the query does not give bad results past "14587847,flng" if that record is in the scope of the search of course. A query including that record whithout the simple text option gives a correct result, it appears that the User ID of the problematic record is "flng<LN". Probably the "<" character gives the problems...

Jacob

[James Heinrich]

Originally Posted by S485122

..."flng<LN". Probably the "<" character gives the problems...

As per posts #53/54 above. The "<LN " is interpreted as the start of a new HTML tag and the rest of the page is trying to be interpreted as parameters of the "<LN></LN>" tag, which is why it doesn't show up. All data output in the report should be escaped for HTML special characters (e.g. "<" becomes "&lt;", etc.)

[Prime95]

Originally Posted by James Heinrich

However, normal HTML rules still apply inside <pre> tags, you need to escape special characters, in PHP you'd do it like:

echo '<pre>'.htmlspecialchars($text).'</pre>';

Thanks James. Your fix has been applied.

[Prime95]

Originally Posted by Batalov

[odbc_query_rows_array() 152125.65 ms

Fixed. Creating the index - easy. Forcing SQLServer to use it - quite difficult.

[Batalov]

Thanks, this was fast. And it works fast.

Another request - for a single p, could we see all three SQL reports in one page -
http://v5www.mersenne.org/report_fac...xp_lo=36771277
http://v5www.mersenne.org/report_fac...xp_lo=36771277
http://v5www.mersenne.org/report_ll/?exp_lo=36771277

==> in one webpage, e.g.
http://v5www.mersenne.org/report/?exp=36771277 plus optionally
"XXX has reserved it and has YY% progress in stage ##".

And yet another (obviates the previous) - the reverse V5-to-V4 bridge (send some V5 data back into V4 database). You know, a lot of exponents are marked "*" in V4 reports while via V5 reports it is clear that P-1 was done and the "*" should have been erased in V4 individual progress reports (avoiding unnecessary work).

[crash893]

I just recently started on v5

i noticed that when i did the client droped the number it was currently working on and started a new one assigned from the v5 server.

I dont mind i will just add it to the work to do for a diffrent client but is there a way to have the clients finish up what they are doing then move over?

[S485122]

I hope I did not miss something. It would be nice to have the possibility of loggin in automatically to ones account on the V5 server. It could be done via a cookie or the way it is handled on the V4 server or some other way... But I do not use the feature remember password on my computers for obvious reasons. The PrimeNet password is an exception that will not have me change the settings of Firefox or IE. I manage the cookies via Spy-Bot's exception list.

Suggestion sent to Scott via E-Mail as well.

Jacob

[crash893]

Originally Posted by S485122

I hope I did not miss something. It would be nice to have the possibility of loggin in automatically to ones account on the V5 server. It could be done via a cookie or the way it is handled on the V4 server or some other way... But I do not use the feature remember password on my computers for obvious reasons. The PrimeNet password is an exception that will not have me change the settings of Firefox or IE. I manage the cookies via Spy-Bot's exception list.

Suggestion sent to Scott via E-Mail as well.

Jacob

you can catch the url it sends that has your name and password in it and save that as your page rather than the home page


for example mine is

htt p://v5 ww w.merse nne.org/mem ber/?use r_login=cra sh893&us er_passwor d=xxxxx xx &B1= GO

sorry i had to add some spaces to keep it from being a url and truncating it

[retina]

Is the milestones page "live" or periodically (p)recompiled?

There is no date to show when it was last updated. Perhaps some kind programmer could add a line to say the date of generation?

[Prime95]

It is actually live. However, the data only changes significantly when I download v4 results and upload them to the v5 server.

When the v4-to-v5 bridge is working the changes will occur frequently