Fast Access of DATA
-
Hi, As per the three module of development (related to data access from SQL to the front -end and reports on Html)i have developed (ASP.net With c#) n tested it. Its running ok. Speed is also fine as compare to Crystal Report. Sincearly i have no idea about how the data comes from SQL (format)to the main application. Is there any better solution.. if there is then plzz kindly reply me.. sincerly, Shriya
-
Hi, As per the three module of development (related to data access from SQL to the front -end and reports on Html)i have developed (ASP.net With c#) n tested it. Its running ok. Speed is also fine as compare to Crystal Report. Sincearly i have no idea about how the data comes from SQL (format)to the main application. Is there any better solution.. if there is then plzz kindly reply me.. sincerly, Shriya
DataReader is faster than other control but it's connected and forward only. u can choose as per your requirement.
Keep Smiling !!! Parwej Ahamad g_parwez@rediffmail.com
-
DataReader is faster than other control but it's connected and forward only. u can choose as per your requirement.
Keep Smiling !!! Parwej Ahamad g_parwez@rediffmail.com
Thnx For your precious reply, ya, i have choosen Reader, thts absolutely right.. I mean if there is any other way which can increase the performaence in terms of time. Regards, Shriya
-
Thnx For your precious reply, ya, i have choosen Reader, thts absolutely right.. I mean if there is any other way which can increase the performaence in terms of time. Regards, Shriya
* You can try an optimise the queries you are using. * You can return the minimum information (saving on network bandwidth and memory in the SQL Server) * You can install a faster network * You can install more memory in the SQL Server * You can install faster hard disks in the SQL Server * You can fine tune the indexes on the tables I could go on if you wish, but you would be better buying a book on how databases work.
Upcoming Scottish Developers events: * We are starting a series of events in Glasgow in 2007. Are you interested in a particular subject, or as a speaker? * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog | Photos
-
Thnx For your precious reply, ya, i have choosen Reader, thts absolutely right.. I mean if there is any other way which can increase the performaence in terms of time. Regards, Shriya
-
Thnx for reply, sorry for late respose from my side.. regars Shriya
-
* You can try an optimise the queries you are using. * You can return the minimum information (saving on network bandwidth and memory in the SQL Server) * You can install a faster network * You can install more memory in the SQL Server * You can install faster hard disks in the SQL Server * You can fine tune the indexes on the tables I could go on if you wish, but you would be better buying a book on how databases work.
Upcoming Scottish Developers events: * We are starting a series of events in Glasgow in 2007. Are you interested in a particular subject, or as a speaker? * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog | Photos
Thnx for reply, sorry for late respose from my side.. regars Shriya
-
Thnx for reply, sorry for late respose from my side.. regars Shriya
Thanx :laugh:
Keep Smiling !!! Parwej Ahamad g_parwez@rediffmail.com