lets say this is an example. Lets say I have table A with 100 random numbers between 0 and 9
I will provide how many items I want, lets say 10 (this number I need to be able to change). I need then to read last 10 entries in that table A and find out number of occurrences of each of those digits.
then based on the number of occupancies I like to display the highest choices based on the following criteria:
1. If we have two digits tied for the top pick, use only those digits, plus the second best digit (with ties) in our combinations.
2. If there are three or more digits tied for the highest frequency, use only those digits for that position.
3. If we have two or more digits tied for the second highest frequency in a position, use the highest and the second highest digit with ties.
4. If we have any ties with the third highest frequency digit use only the top and second picks.
I did play with mysql while back and I know a lot of those frequencies can be handled inside mysql, I prefer to use mysql for it rather than getting items from DB to php and then processing it as speed might be a factor. I think mysql can handle large quantities of numbers much better than php would. But I need php so I can integrate it into my website.","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":270131},"skills":["MySQL Administration","MySQL Programming"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-07-26T21:36:36+05:30","url":"https://www.toogit.com/freelance-jobs/MjcwMTMx"}
Remote Web Development Job In IT And Programming
Find more Web Development remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekFixed Type
Remote Job$23.95
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
API Development
1. The application development must be on PHP/ Laravel framework.
2. The application development must be compatible with different laravel application hosting on same domain on folder basis.
3. The API to be capable o...read more
Looking for someone to set up a simple (HA) master-slave MySQL with a load balancer.
This is not be going into production but more for testing and a template.
i need help with django unit testing, its an ongoing project. but i will give flexible hours, you can work on weekends or weekdays, whenever you want you can work there is no particular time to work for me.
Need mobile applications for iOS and Android code to work.
Details:
Database:MYSQL
NodeJS
Angular
Currently AWS has Elastic beanstalk instance but its in critical state.
Lightsail VPS instance Linux
EC2 Instanc...read more
I need someone that optimize my mariadb servers settings to improve the performance for these needs:
A table with 200 million records and 20 gigas size.
The table has 21 partitions, and is replicated in master-master mode with 2 servers<...read more