From the network side, there aren't many options for optimizing your database other than throwing bandwidth at the problem. As database and hardware technologies advance, though, more developers will tackle solutions for reducing database traffic. Until then, it's up to you and your packet sniffers.
Don MacVittie is an applied technologist at WPS Resources. Write to him at [email protected].
Post a comment or question on this story.
How to reduce Database Traffic on Your Network
1. Use a network packet sniffer to track down problem applications. The sniffer shows you how many times a database query creates connections, and how much data is being transferred.
2. Check your SQL. Look for queries that return more rows than the program needs or more columns than the application uses. Combine multiple queries into a single query, if possible. If a SQL statement selects one or two fields from a table and another SQL statement uses this information to get data from another table, for example, then merge the two into a single statement that returns data from both tables.
By combining resources and expertise, the AI-Enabled ICT Workforce Consortium will offer a blueprint for how industries can adapt to an AI-dominated future.
IT leaders should heed the guidance of cybersecurity insurance providers who think businesses should prioritize security education, incident preparedness, regular internal audits, and ongoing vulnerability scanning and patching.
There are many network courses that can address your present job's priorities and help you gain the needed skills to keep pace with industry changes and new technologies.
