Hi neuralynx,
No only one of the {if} statements will run depending on the outcome of the conditional.
You can easily test this by going to Admin > System Administration > Output and Debugging and turning on Display Output Profiler.
If you place this code in your template and nothing else :
{exp:channel:entries
channel="default_site"
disable="member_data|trackbacks|categories|category_fields|pagination"}
Place all your repeating code here for showing the six items in a row
{/exp:channel:entries}
Take a look at the output profiler to see how many queries are produced when you run that then change the code for the code I posted above (shown again here below) :
{exp:channel:entries
channel="default_site"
disable="member_data|trackbacks|categories|category_fields|pagination"}
{if total_results <= "6"}
Place all your repeating code here for showing the six items in a row
{/if}
{if total_results > "6"}
Place your repeating code here for your carousel
{/if}
{/exp:channel:entries}
Note how many queries it uses this time. They should be the same hopefully.
Does that help?
Thanks,
Mark