T
Tim Hutchens
Guest
mitreddep, Since no one mentioned it yet, I would also want to investigate whether there are proper indexes for the queries that are slow. A query that searches on a set of fields that don't have appropriate indexes will be forced to use the default index or do a whole table scan, which depending on the table size could significantly reduce your performance. I know your question was more specifically about hardware, but I wanted to point out that indexes can contribute to performance. Not sure if your external support team will be able to look into the indexes for you. If the whole application is equally slow for large queries on different tables, that would lead me toward hardware and network parameter tuning as others are suggesting. Tim
Continue reading...
Continue reading...