does large data affect the performance of overall application?

Question

1.00/5 (1 vote)

See more:

Hi All,

I have an web application which stored record in the database. it has 50 to 60 tables but frequency of data storage is high only on 6 to 7 tables. other tables are like master table and have fix data. Now i have one more table for audit trial of these 6 to 7 tables and it stored each field value of table for insert , update and delete operation. So, basically this table grows on a large scale as compare to other tables.

However these audit trial data generally used less and only for back up / security purpose.

Now my query is if we apply proper select query when this audit trial data call than apart from large data (more memory size for mdf / ldf file) in the database , does it affect the overall performance of the application?

Posted 15-Jun-15 17:50pm

ravikhoda

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2015-06-15T18:19:00

Solution 2

The answer is "it depends", on lots of factors such as how you're writing your code and exactly what you're doing with the data and how much of it. Are you setting up the SQL Server on the same machine as the application? Is it configured properly? Is your database constructed appropriately? Correct indexing? Is there any caching of data involved? The list of questions and possibilities is seemingly endless. There is really no way to give you a concrete answer.

Posted 15-Jun-15 18:19pm

Dave Kreskowiak

Comments

Mehdi Gholam 16-Jun-15 0:24am

Yes, 5'ed

ravikhoda 16-Jun-15 3:05am

well these data will not generally called or used anywhere ..its only used by site admin to check in case normal user delete some data by mistake or update some wrong value for particular record. So basically the data only stored in that table using trigger but not load on any page by normal user. my concern is only that it will enter lots of record in that particular table and it will grow the size of the database. other tables of the database are indexed properly.

Dave Kreskowiak 16-Jun-15 8:22am

If you're saying that you just have a bunch of data stored in a database and not being used very much at all and you're not really adding to it, then no, it won't affect the performance of your application.

ravikhoda 16-Jun-15 23:50pm

Thanks

KevinD'souza · Answer 2 · 2015-06-15T18:17:00

Solution 1

It should affect a little but not too much... If it does then apply proper indexes on the tables

Posted 15-Jun-15 18:17pm

KevinD'souza

Member 10572607 · Answer 3 · 2015-06-15T18:21:00

Solution 3

If you are using gridview or loading all data in once than it will affect performance in that case you can use Custom paging.

Posted 15-Jun-15 18:21pm

Member 10572607