too slow, ~12 sec for load

[eluser]davidino86[/eluser]
[quote author="Xperia" date="1280255340"]Just had a quick look, you have a lot of DB queries that do add upp, like:

Code:

0.0006       SELECT Impressions
FROM AdvertisingBanner
WHERE ID_Banner = 'AC72C24A-045E-4638-9387-5990546DE55F'
0.0695       UPDATE AdvertisingBanner SET Impressions = 1910 WHERE ID_Banner = 'AC72C24A-045E-4638-9387-5990546DE55F'

You should just do it with just one DB statement, like:

Code:

UPDATE AdvertisingBanner SET Impressions = Impressions+1 WHERE ID_Banner = 'AC72C24A-045E-4638-9387-5990546DE55F'

[/quote]

the second query i apart from the first and it 's like you wrote