ADVenturePO Posted March 15, 2018 Share Posted March 15, 2018 Hello, @richba5tard @Christian Ney@der8auer@websmile I'am an active overclocker with a lots of benchmarks. HWBOT is not only a OC-sport for me, but also a database of hardware efficiency. Since the appliance of a HWBOT rev 7 we see a lot of confusion. A lot of wrongly given or taken points. I have few qustions: 1. Is there one or more databases? 2. Does every benchmark have its own database or table? 3. How many machines (or virtual machines) are there? Suggestions There should be: SID - Score Individual Number and A USer best record in Tables of database. I. Main Benchmark Database (DB1) - build of tables of scores with records for the benchmarks only.This database is served by (virtual) Machine 1 Table SuperPi 1M Score / User /Cpu / RAM / GPU .... / Score Individual Number (SID) / SUFFIX (www address suffix) and etc. II. Hardware-Benchmark (DB2) database which is build and updated by (Virtual) Machine 2 With tables containing only hardware specific benchmark results. It is build and kept up to date - rebuild, accordingly to Main Benchmark DatabaseEach table represents hardware and benchmark and it is build by Machine nr 2 just by collecting scores with specific hardware from DB1. Table Super Pi 1M with i7-2600k Score / User / RAM / GPU .... Score Individual Number etc. III. Global Points-per-score in benchmark DataBase (DB3) with its own Machine 3 It's build accordingly to database number 1 accordingly to scores Table GL_SuperPi 1M Score / SID / Users best? / Global Points Achieved IV Hardware points-per-score in benchmark database (DB4) with its own Machine 4 It's build accordingly to database number 2 accordingly to scores obtained with specific hardware Table HW_SuperPi 1M Score / User / SID / Users best? / Global Points Achieved --------------------- You can add as many databases for points as You like. --------------------- V. User scores database (DB5) with Machine 5 Holds each best score for the benchmark - And this table is created as a full-lenght info Table Benchmark/ SID / CPU / GPU / Users best? / Global score / HW / Score .........etc VI. League ranking, Global Ranking- (DB6) where Machine 6 is only counting points from database V Table User / Global Points/ HW Points ... etc VII. WWW serwer Database is creating a page of the benchmark accordingly to the benchmark score www suffix, but under the time of calculation the virtual machines are given data, and each one is sending data to WWW compiler after they have had finished calculating. Machine 1 is sending some data of the benchmark which is sufficient to create a page - ex. Suffix / SID /User / Score/ Pictures / Hardware data imputed into the submission form. Machine 2 is not sending anything but asked torebuild database Macines 3 and 4 (or more of them) are rebuilding tables and sending points to WWW Serwer (VII) and User Score database (V) Machine 5 User Score Database is sending points to Machine 6 and its sending data to WWW server or WWW Serwer is retrieving the data by itself. It's complicated. It would take probably a bit longer but would be much more reliable and all data would be changed at once. You can apply any mathematics to the Machines 4 and 5 and any other that are only building Points databases That is my idea how it might work. It is not an opinion of a specialist as I'm who is able to make many very specialized Excel formulas for many different things but is not a specialist about databases. Right now, I know there is a submission number but it's exchanges with a WWW suffix when a submission isn't the user's best score. There is no Users best record - as for examples: http://hwbot.org/submission/3808128_ and at this page there is a link to a best submission: http://hwbot.org/submission/3806911_adventurepo_catzilla___720p_geforce_gtx_1080_ti_56547_marks And that is with almost all my submissions from last two days with Titan V and i9 7960x... Points were changing all the time... but those submissions stays the same: all of them suggest there is a better score -> click - it's much worse, - Click - better hardware -> Error http://hwbot.org/submission/3808303_ http://hwbot.org/submission/3808125_ http://hwbot.org/submission/3808121_ http://hwbot.org/submission/3808119_ http://hwbot.org/submission/3808117_ http://hwbot.org/submission/3808115_ http://hwbot.org/submission/3807925_ http://hwbot.org/submission/3807924_ http://hwbot.org/submission/3807720_ I hope I helped. Peter Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.