Results 1 to 5 of 5

Thread: PrimeGrid Subproject Sorting

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    By 5000 you mean 'entries' right? if so, it looks like it would take around 25-30k to cover the majority of sub-projects. Is that too much? (no bandwidth problems here either)
    I don't mind if its only on stats6, as I'm probably one of the few who visit these pages.

    I can always live with the 'Last Update' column if its too much of a hassle.
    Last edited by Emoga; 03-03-2020 at 06:29 PM.

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,501
    Blog Entries
    13
    hmm, take a look at stats6 now. I made a few tweaks to the sql. You can sort on yesterday and today now, though it only shows those rows that have data in that particular column which might actually be the preferred goal anyway.

    While it's not using an index for the sorting on those columns as they are derived fields (I could create a view and use that if necessary) given the result sets are still fairly small I think it's ok. Runs pretty quick for me anyway, but I'm on the same network as the server.

    If it seems to be working ok, I can push this over to the main stats too.

  3. #3
    Works great for me. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •