I am running vb.net applications on a sytem with 512 mb of ram. The project includes retrieving data from a database which has approx. 20-25 lac records.

On running the project for the first time itself, either a "time-out" message appears or the system gets hanged up.

I tried clearing up all the application, security and system events from the event viewer but to no help.

What should I do? Is the ram specified insufficient?


I doubt is Memory as I am running VB.NET Apps on Client PCs with 256Mb RAM and they run at a good speed

and the SQL lag is about 0-3 seconds

I would look at
1. What else is running on that PC
2. Is your SQL Code efficient
3. LAN Speed
4. Remaining RAM
5. SQL Server Workload