MYSQL PHP Data Analytics project - need an elegant solution

Request detail

Hi. I have a MYSQL database with 1,000,000 podcast episodes.

Currently I am labelling the episodes by topic e.g "India" or "Machine Learning" or "True Crime". This system using simple match(title,description) against ('India') for example, storing into a cached results table e.g (episodeid, topicid, match_strength).

While this is easy it’s slow i.e. I have to create cached results to access them. If we have 500+ topics it will require multiple cron jobs to update database regularly.

My end goal is to catalogue all the podcasts under topics.

I’m looking for a more elegant method to do this, especially as we go from 1m -> 10m episodes. Interested to chat?

Our system is built on PHP MYSQL so all solutions will need to reflect this, thanks.

Evner: PHP, MySQL, Database Administration

Se mere: mysql php data check, simple mysql php data entry form, mysql php data mail attachment, php data entry project online, mysql php data viewer, mysql php data popup, ajax mysql php data webpage, freelance data analytics project, how to get a freelance data analytics project in uk quora, singapore freelance data analytics project, where can i find data analytics project as a free lance, data analytics project topics, data analytics project in r, big data analytics project management pdf, data analytics project example, data analytics project

Om arbejdsgiveren:
( 0 bedømmelser ) Tokyo, Japan

Projekt ID: #31935710

10 freelancere byder i gennemsnit $7/timen for dette job


Hi there, ★★★ PHP / MySQL Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to make catalogue all the podcasts under topics.. Websites we built with PHP: ✔ [login to view URL] ✔ http://banc Flere

$8 USD / time
(253 bedømmelser)
(97 bedømmelser)

Hello, Thanks for reviewing my application. I analyze job requirements for a PHP developer, So I am well familiar with the requirements and will surely help you in this project and I'm able to start right now. I have Flere

$8 USD / time
(29 bedømmelser)

Hello :D Maybe I can help you with the project I have experiences dealing with PHP development I can show you my previous works demo done in PHP Before I did a project where, I merged PHP script will python to do the Flere

$8 USD / time
(11 bedømmelser)

Hi. I'm Duyen from Vietnam. I'm very interested in your job, I'll do it as fast as I can. I've read requirements and I'm ready. I' m now free, so I have no problem with investing all my available time until you sati Flere

$5 USD / time
(1 bedømmelse)

Hi, I am a web designer & developer with 9+ years of experience. I have expertise in Laravel, CodeIgniter, Magento, WordPress, API, CMS, ecommerce, JavaScript, HTML, CSS, MySQL, PHP, Angular, React, React Native, Vue.j Flere

$8 USD / time
(4 bedømmelser)

Hello I have 8+ years of experience in web development using php and its framework laravel,codeigniter I can do your work .My recent work Urls [login to view URL] [login to view URL] [login to view URL] https Flere

$4 USD / time
(3 bedømmelser)

"Hi, Hope you are doing well! I read project description and I can do your [login to view URL] we already work on similar requirement in past. I can even work on urgent basis and I Have 7+ years of work experience in PHP Flere

$5 USD / time
(4 bedømmelser)

I read your description.I have some specific questions to [login to view URL] open chat so that we can discuss.

$5 USD / time
(0 bedømmelser)

Hi. I am a web developer and a computer science student interested in data processing. your description is good but I need a more clear understanding of your approach to give a better solution. I don't know maybe we c Flere

$5 USD / time
(0 bedømmelser)