Thanks Craig, that was my suspicion.
>The stored procedure can be pre-compiled, causing it to execute faster.
>
>>Does anyone know if there is a major difference between making a connection to SQL Server in Java and sending a query or making the connection and executing a stored procedure?
>>
>>I am new to Java and trying to optimize a database. Currently most of the SELECTS, INSERTS, DELETES and UPDATES are sent to SQL Server from Java Server Pages. My guess would be that having a stored procedure would be better since sending the query from JSP every time would require SQL Server to create a new plan each time.
>>
>>Any help on this and/or where I can go for documention on this topic would be great.
>>
>>Thanks!
>>George
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe