In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
select max(study_custom1) as 'Outside Institution', COUNT(study_custom1) as 'Number of Studies' from pacsdb.study where accession_no like '%OUT%' and study_custom1 is not null and created_time >= DATE_FORMAT( CURRENT_DATE - INTERVAL 1 MONTH, '%Y/%m/01' ) AND created_time < DATE_FORMAT( CURRENT_DATE, '%Y/%m/01' ) group by study_custom1 order by 'Number of Studies' DESC
site3 5 site2 8 site8 2 site4 1 site1 12
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.