On the morning meeting with the guys. We were looking into stuff on data 5. We found that there were 10,000+ hits on the searchQuotes API socket. That is 1 hit every 5-10 seconds. That method alone was joining 4 or 5 tables and filtering through 500,000 records per call. We got Calvin on the meeting and then talked about possible options and watched some of the CPU monitors on the data 5 box. We talked about a number of possible solutions.

- talked about options such as: indexing queries, tables, re-writing API sockets, looking into ColdFusion settings, bigger processors, more ram, etc.

Towards the end of the session, we also looked into the refresh rate and queries that run on the mmj_home_2.cfm page. This one was doing a refresh and joining 150,000 customer records and 500,000 invoices per corp to figure out the top 15 customers. This query was being run as part of their homepage with an auto refresh rate. We talked about running that query and then doing a local cache of that data on a per day basis vs every page request. Just looking for ways to speed things up.