i think, iam using sql 2005.. i will try to download 2008 express edition and copy the database to it..

Ok fine then, i will do onething. i will try to download new version of sql and try it..

yes, iam sure i have used index..

no the table does not have clustered index and the table is not fragmented... The table is new table and it has only 4-5...

ok here is the information

Execution Tree

--------------

Sort(ORDER BY:([ProductDetail].[ProductName] ASC))

|--Table Scan(OBJECT:([SuperShop].[dbo].[ProductDetail]), WHERE:([ProductDetail].[ProductName]>=[@1]))

--------------

in below text first duration was just 33, which was gradually increased to 1500 and 1406

vent ClassDurationConnection IDSPIDStart Time

...

yes i have created index and tried... still same problem...

And i dont know how to take graphical output... the zip file has trace file, and you can open using "sql...

hi, please let me know if you need any other details regards this issue

Hi guys, sorry for the delay....

here i have attached the trace file with this reply, it have the execution plan... i think, it will help you to provide me...

thanks for your replies,

since it in development phase iam using the default username and password. later i will change it to new password.

i have not used indexing on my table....

actual...

no i have not used indexing...

here is my coding

SqlConnection conn = new SqlConnection();

conn = new SqlConnection("Data Source=10.0.0.2;Database=SuperShop;User ID=sa;Password=sa;");

...

i did not use any connection pool.

iam doing this software for an super market, so if they keep on pressing up or down arrow.. value has to be...