Index  | Recent Threads  | Unanswered Threads  | Who's Active  | Guidelines  | Search
 

Quick Go »
No member browsing this thread
Thread Status: Active
Total posts in this thread: 6
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 6280 times and has 5 replies Next Thread
SNURK
Veteran Cruncher
The Netherlands
Joined: Nov 26, 2007
Post Count: 1217
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Since database update the user.gz file is sorted differently [RESOLVED]

I noticed that the user.gz output file is sorted in a different way since jan 14th/15th. This seems to coincide with the database maintenance. In the past it was sorted on <id> ascending. Now it seems to be sorted on <total_credit> ascending.
My script that extracts data from this file for the signatures is failing, because it depends on the data being sorted on user id.
Is this a mistake or will the user.gz file remain sorted this way? If yes, I would like to know, because then I have to do some re-coding.

Thanks,
SNURK
----------------------------------------
----------------------------------------
[Edit 2 times, last edit by SNURK at Jan 17, 2012 9:14:13 AM]
[Jan 16, 2012 11:10:18 AM]   Link   Report threatening or abusive post: please login first  Go to top 
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
Re: Since database update the user.gz file is sorted differently

Auch, hope not. Could be impacting multiple stats aggregators.

--//--
[Jan 16, 2012 11:51:55 AM]   Link   Report threatening or abusive post: please login first  Go to top 
knreed
Former World Community Grid Tech
Joined: Nov 8, 2004
Post Count: 4504
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: Since database update the user.gz file is sorted differently

Interesting - there was no sort order specified in the export script. I've added that since clearly the reorg due to the update caused the export order to change.
[Jan 16, 2012 7:19:23 PM]   Link   Report threatening or abusive post: please login first  Go to top 
SNURK
Veteran Cruncher
The Netherlands
Joined: Nov 26, 2007
Post Count: 1217
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: Since database update the user.gz file is sorted differently

Thumbs up! Everything is back to normal.
----------------------------------------
[Jan 17, 2012 9:16:18 AM]   Link   Report threatening or abusive post: please login first  Go to top 
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
Re: Since database update the user.gz file is sorted differently

Hi Team :), As I can have a sig, as Leo?
[Jan 19, 2012 9:43:16 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
Re: Since database update the user.gz file is sorted differently

Hola ask for it

here smile
[Jan 19, 2012 10:27:38 PM]   Link   Report threatening or abusive post: please login first  Go to top 
[ Jump to Last Post ]
Post new Thread