jitendra

• Jul 14th, 2007

 

Hi

The best way to solve this problem use web tester like funkload web tester is free. Thanks

Ganesh

• Sep 7th, 2007

 

The effect is on the performance. If the queries are not properly designed, it can stagate the pages where the data is retrieved from database. But we can always go for indexes, hints (in Oracle), or limit(MySql) to improve the performance.

lambedanish313

 Profile Answers by lambedanish313 

• Apr 9th, 2009

 

There will be no bad effect until you fetch lot of rows on page, or you fire lot of queries on page.

bhavsarpr

 Profile Answers by bhavsarpr 

• Jun 9th, 2009

 

Following can be effect of large number of data stored in a database on a website.

1. Site Can become really slow in case queries used are not proper and code logic for processing large data is not proper.

2. Database can become slow if proper table indexing is not done for large data.

3. Proper Database Engine should be used for Mysql for large data so that we can get results faster.

4. Mysql should be configured properly to respond to query on large data stored.

pankajkhairnar

 Profile Answers by pankajkhairnar 

• Aug 28th, 2009

 

Website will get slow by large number of data but it can be reduced to as minimal as really less data by using some database techniques like.

Indexing the columns which you want to use for search or comparing with other columns.

There ary many techniques which many sites uses to reduce the effect of large data.