I have an ASP.NET application and SQL Server as its DB. When the database was small everything was fine, as now the DB contains huge amount of data. It seems it skip out some calculation.
Application: It calculates the commission of particular agent (like affiliate) for self and its chain (Upline).
Front End: ASP.Net / C#
DB: MS SQL Server 2005
Server: Windows 2003 Shared Server (Web Hosting service taken from 3rd party)
Problem: Skip calculation specially in case of chain commission. Not for all, only few.
So, please suggest me a solution. Is this is because of it has been hosted on shared server? or what ever the reason behind this, please help me out.