MySQL EXPERT: resolve very slow query issue & DB optimisation

SQL expert here, verified in the top 3% of all freelancers globally via freelancer certifications. Please share additional details with me for a full diagnosis: 1) What is the code behind the `get_text` function? 2) Do you have any indexes set up in the database? 3) How many rows are there in each of the tables?

I have experience in deploying and maintaining of: Cloud Computing Platforms: AWS Amazon Web Services,Microsoft AZURE, Google Cloud (GCP). Server Operating Systems: Windows Server 2003-to-2012R2, Windows Server 2016 Amazon Linux, Debian, RHEL, CentOS, Ubuntu. Web servers and servlets containers: IIS, APACHE, NGINX, DOCKER Mail servers: POSTFIX, EXIM, MS Exchange 2000-to-2013, MS Exchange 2016, QMAIL Database servers: MySQL, MS SQL Virtualization: MS Hyper-V, VMware Server(ESXI), VirtualBox. Directory service: Active Directory, OpenLDAP. File servers: IIS FTP, proftpd, FileZilla FTP Server, SAMBA. Firewalls: Windows firewall,ISA/Forefront TMG, MikroTik,PFSense Zywall and other Routers; Data Storage Systems: Netapp, FAS, EMC, VNX Virtual Private Network (VPN) OpenVPN, IPSEC,P2P,S2S VPN, Microsoft VPN, OpenConnect VPN , Mikrotik VPN , PFsense VPN. Hosting Panels: PLESK,cPanel,Website Panel

Hi! As I see in your table articles need to add index. I need to see full structure of this table, because from screenshot it's not enough

Hi, Sir I have just read about your project. That's my WANTED task! I am Python expert with Latest Technologies & Web developer with rich experience. If you give me the opportunity to have your task EXCEPT other bids,,, I will do my best for you. Now, I have full time. Please message me so that we can discuss about the requirement and budget. Thank you Carlos

I can you to improve the performance of your SQL statements. Initiate the chat and award me the contract to complete your project.

Hi We have a team of experienced database development Experience: 10yrs Duration : will complete in 3 to 4 hours Happy to work with you Relevant Skills and Experience 10yrs of database experience

I work with MySQL and I can help you with querying performance and analysis. I must have remote access to server due to make some validations. Feel free to contact me as desired and with confident. I also can assist you to identify hardware problems.