GENiALi's Blog

After the first tuning attempts, it was already essential
better to SQL Server. I had in my applications logs
time out's no more. So far so good.

Easter I read but on the Profiler run to look
whether more queries take that have a long term.

These two queries are arranged me.

CheckFlagTransform is a bit field.

Familiar with only 0 or 1.
The table has today (shareholder) the 8.4 million record's in it.
The count is always between 200 and 10'000 row's.

So sometimes, I created an index on the field CheckFlagTransform.

This time the surprise was great. Of prior
> 60'000ms remained still < 1'000ms left. This query
was faster with a simple index factors.

It was only necessary here.