Hello, I want to know the difference between sp_prepare and sp_prepexec in term of performance. Jtds : sp_prepare + sp_exec in batch Microsoft jdbc : sp_prepexec + sp_exec in batch I use Jdbc driver of Microsoft (the last) and Jtds. For my processes, there are this difference and the microsoft driver seems to have less batch processing than Jtds. Is it correct and have an idea of the best performance : sp_prepare + sp_exec with large batch or sp_prepexec + sp_exec with few batch. Thanks,