select count(*) from result
will not return a high enough number if you have been deleting tasks from
the table as items are moved to the master science database (or wherever
you move the validated results). The result table is vastly smaller than
you might expect in this case.
jm7
Kunsheng Chen
<[email protected]>
Sent by: To
<boinc_dev-bounce yoyo <[email protected]>
[email protected] cc
u> [email protected]
Subject
Re: [boinc_dev] About grant credits
11/05/2009 03:01 in Mysql
PM
How could I take care of the expavg_credit in user table?
For total_credit , I can do something like that:
update user set total_credit = 10*(select count(*) from result where
validate_state = 3 where userid = user.id),
but that expavg_credit is equals to credits/num of tasks... most of which
might be deleted by the database already ?
--- On Wed, 11/4/09, yoyo <[email protected]> wrote:
From: yoyo <[email protected]>
Subject: Re: [boinc_dev] About grant credits in Mysql
To: "Kunsheng Chen" <[email protected]>
Cc: [email protected]
Date: Wednesday, November 4, 2009, 6:15 PM
You must also add these credits in the user- and team table.
Kunsheng Chen wrote:
I am thinking of granting credits for users mannually in mysql. am
wondering if it is enough if I just update 'granted_credit' inside table
result ? Or some other consistency have to be made too ?
Thanks,
-Kun
_______________________________________________
boinc_dev mailing list
[email protected]
http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev
To unsubscribe, visit the above URL and
(near bottom of page) enter your email address.
--
sig
Rate
Me, MySkype (yoyo_rkn)
, myICQ 139003243 , myIRC
Rechenkraft.net e.V. -
Verein
zur Förderung von Bildung, Forschung und
Wissenschaft durch Einsatz vernetzter Computer
weitere interessante Projekte
und Hilfe
auf unserer Webseite www.Rechenkraft.net
und im Chat
Rechenkraft.net
- Germany's
largest distributed computing community. We make those things possible
that supercomputers don't.
_______________________________________________
boinc_dev mailing list
[email protected]
http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev
To unsubscribe, visit the above URL and
(near bottom of page) enter your email address.
_______________________________________________
boinc_dev mailing list
[email protected]
http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev
To unsubscribe, visit the above URL and
(near bottom of page) enter your email address.
