sp execute problem
-
i'm using vb.net (VS2005) and Ms sql 2005 when i'm executing sp using my code(executenonquery) it takes more than 10minutes but when i'm run it normaly(like a sql query in Ms sql2005)it takes only 3seconds. i created same sp with different name and executed using code.that time it takes only 3seconds(same as normal execute). in first time, whats da reason for takes long time?anyon can help me? Thnks you
-
i'm using vb.net (VS2005) and Ms sql 2005 when i'm executing sp using my code(executenonquery) it takes more than 10minutes but when i'm run it normaly(like a sql query in Ms sql2005)it takes only 3seconds. i created same sp with different name and executed using code.that time it takes only 3seconds(same as normal execute). in first time, whats da reason for takes long time?anyon can help me? Thnks you
can you write how you call sp from VB
Regards, Rami Sa'id Abdalhalim Technical Team Leader Amman Commercial Complex Ommayah Str. Al-Abdali Tel: +962 6 5696500 Ext.235 Mobile:+962 79 5366016 Email:r.abdalhalim@alghanem.com.jo www.alghanemgroup.com