We are using the new cool Macro Container on our new sites. But now the backend (Editing documents with the macro container as property) are getting slow and slower.
When I debug the solution with visual studio I can see that 21.000 sql queries executes when cliking a document inside umbraco. :-( it takes over 20 seconds to get a response.
We are using umbraco v
4.5.1
If I change the property from Macro Container to Multple line it only executes 111 queries.
Does any body know how to fix this? I can not see the bug in release 4.5.2.
We have 50 Macros in total, 12 allowed macroes on the Macro Container.
Ok, in my first example with 21.000 sql queries I have set the max allowed macroes to 50
If I change this to 5 it only executes 466 sql queries
In all the examples not a single macro has been added to the contianer. Therefore I think this is a bug (badly designed datatype) and I will create a issue on codeplex.
Macro Container Slow: Executing 21.000 sql queries
Hi
We are using the new cool Macro Container on our new sites. But now the backend (Editing documents with the macro container as property) are getting slow and slower.
When I debug the solution with visual studio I can see that 21.000 sql queries executes when cliking a document inside umbraco. :-( it takes over 20 seconds to get a response.
We are using umbraco v 4.5.1
If I change the property from Macro Container to Multple line it only executes 111 queries.
Does any body know how to fix this? I can not see the bug in release 4.5.2.
We have 50 Macros in total, 12 allowed macroes on the Macro Container.
In another solution running v 4.5.2 the macro contianer is also slow.
When I click "Insert macro" on property it executes 4.000 sql queries
Ok, in my first example with 21.000 sql queries I have set the max allowed macroes to 50
If I change this to 5 it only executes 466 sql queries
In all the examples not a single macro has been added to the contianer. Therefore I think this is a bug (badly designed datatype) and I will create a issue on codeplex.
Codeplex issue created
http://umbraco.codeplex.com/workitem/28732
I just got same issue dont know how many queries but it took a long time in the editor to pick a macro. Have voted.
Regards
Ismail
This is definitely a (very ugly) bug. Will be fixed for 4.5.3
is working on a reply...