The primary purpose of motherboards such as this supporting different types/formfactors of RAM is so that users can make use of legacy RAM they may have available from older machines. The downside is that because you cannot use both types of RAM at the same time, you are somewhat limited as to the maximum amount of RAM you can install (compared to other motherboards.
To answer your question, DDR does have double the data transfer of SDRAM (PC133). However, how sigificantly it will affect your performance cannot be directly determined. Will there be enough improvement to actually notice? Probably. How much difference will there be? Unknown. You will have to discover this through experimentation. Prices for same capacity RAM are roughly equivalent.