tags:

views:

77

answers:

1
+1  Q: 

Mysql Large Volume of Queries

What is the best way to optimize a MYSQL server that has 400-1000 queries across 20 tables running against it from 20-30 users?

I have these reports that run against the server and they need anywhere from 400-1000 queries to get all the necessary information. The two issues I am facing are the queries individually are relatively fast but all together take up to 5 minutes to run. The second issue is after about 6 users running reports the whole mysql server just freezes up and I have to restart it. Is mysql not the best choice for this? Any help would be great!

Thank you

+1  A: 

The first thing to check would be that your tables are correctly indexed, this is likely to improve performance significantly if it is not already implemented.

If this data is used for reporting, maybe it would be a good idea to automate the queries and store the results seperately - that way you wouldn't have to run as many queries.

James  2009-10-06 14:51:14

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?