Search results for query: *

20% or even less. The average is between 4%/5% Yes I have indexes on every primary keys and on 98% of the fields that are used for the foreign keys (btw Mysql 4.x does not have yet relations between tables). There aren't also non-clustered indexes on Mysql. The connection roof for the website...

damber, first of all thanks for your tips! Let me coment them Actually putting the XML in the application variable seems to me a pretty good idea! I would access then to the variable and the file access wouldn't be needed. I'll make a few tests on that! I'm already splitting the large ASP page...

yeah probably! I know that there are serious problem with the points i've written. I'm just not quite sure what are the most and the less serious. This kind of problems are sometimes really hard to solve... :(

Thank you all for your answers! RhythmAddict112 I will look for that. The website only uses three session variables: for user id, password and language. I guess it might not be a problem here! Besides that the available memory is always higher than 200MG. I suspect that the problems might be...

Yes Sheco What I would like to know is where i should start first. And if this are really problems that can cause the website to run slower with a little more load.

No. There are several files. But there is a very big include file with global functions of the website. Like: Function getUserName(userId) (...) End Function Function getCityName(cityId) (...) End Function etc. This functions are then called on some of the website pages. Just a note: When I...

Hello all I have a very intense (database driven - mysql) application that is causing me some performance issues when i have more that 350 visitors online. The ASP Request Queue starts to get bigger and the response times get higher and higher. the cpu also goes to 90% or even higher! (the...