I have developed a desktop application in C# that uses Sql Server 2005 express edition to store data.
The database server works fine with small size of data, but now I have more than 10,000 entries in a table, and when I fetch data from this table it takes quite a lot of time.
Also I have created a view on this table which contains some subqueries.
This view is not opening with this data size, and sql server is returning "time out expiration" error.
I do not understand why server is behaving like this with this size of data, after all it is a server.
I have 2.8 processor with 1 GB of RAM.
If someone have knowledge about this issue please tell me.