Lazy Database Access
-
I've more than 24000 records and when i search them, it consume a lot of time and my application suspend for some about 5 to 8 seconds. Is there any way to boots up the access time of records in C# and SQL Server 2000. As compare to vb6 Dot net is very lazy in record access. Thanks.
Syed Shahid Hussain
-
I've more than 24000 records and when i search them, it consume a lot of time and my application suspend for some about 5 to 8 seconds. Is there any way to boots up the access time of records in C# and SQL Server 2000. As compare to vb6 Dot net is very lazy in record access. Thanks.
Syed Shahid Hussain
Do the search on the SQL server with a stored procedure and create appropriate indexes.
-
I've more than 24000 records and when i search them, it consume a lot of time and my application suspend for some about 5 to 8 seconds. Is there any way to boots up the access time of records in C# and SQL Server 2000. As compare to vb6 Dot net is very lazy in record access. Thanks.
Syed Shahid Hussain
Use asnychronous access.
only two letters away from being an asset
-
I've more than 24000 records and when i search them, it consume a lot of time and my application suspend for some about 5 to 8 seconds. Is there any way to boots up the access time of records in C# and SQL Server 2000. As compare to vb6 Dot net is very lazy in record access. Thanks.
Syed Shahid Hussain