V
Vitamin
I am using asp to connect to my MS SQL Server, there have some problems,
could you please help me?
1. take about 5 seconds to make a connection with SQL server:
In other projects, this would not happen, it just happened in my
project? Why?
2. Select MAX() problem
I need using select max(column) from table to get the maximum number of
that column,however, really shit...this function need take about 15 seconds
to finish the job??!!! I am using Query Analyst to test it, it just using
nmot more than 1 second. Oh....Why...???
Regards
Thanks
could you please help me?
1. take about 5 seconds to make a connection with SQL server:
In other projects, this would not happen, it just happened in my
project? Why?
2. Select MAX() problem
I need using select max(column) from table to get the maximum number of
that column,however, really shit...this function need take about 15 seconds
to finish the job??!!! I am using Query Analyst to test it, it just using
nmot more than 1 second. Oh....Why...???
Regards
Thanks