Table size limit 2

[HaveTrouble]

Is there a limit of how many rows of data can be in a table ? We have a web form with SQL statement to insert data directly to a table. It produces timeout error once a while after table reaches 300,000+ rows. Is it because the table size reaches the limit ?

 

[jbenson001]

If you are getting a timeout issue, you have to check the timout paramter that is set on the server.

 

[kizziebutler]

I have 100 million records in my table, your name is relatively small. You need to check to see if you have enough space on your server for the database files to grow. Check your configuration, what version of sql are you using and have you the lastest service pack. Is your PC a good spec computer.

 

[mrdenny]

Even 100 million records in a table is small. I've worked with tables that are over 1 billion records in the table. 300,000 records is nothing.

Ensure that the data has enough space (you may be getting time outs while waiting for the database to grow). Your indexes may need to be rebuilt to free up some space on the pages.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[HaveTrouble]

Does it make any difference if the insert statement is inserting data directly into table ? I came across some articles before about insert data into views but can't remember exactly why.

 

[jbenson001]

Check all that was sugggested here, timeout value, size, indexes etc.

 

[mrdenny]

No it shouldn't make any difference if it's inserting directly into a table or through a view. Inserts directly into a table will be better however.


Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[chiph]

I would investigate the index structure of the table. There might be indexes on fields that don't have much selectivity (bit fields!), or on fields that you normally wouldn't query against (unique identifiers) that are causing inserts to time out.

Chip H.


____________________________________________________________________
Donate to Katrina relief:

http://s1.amazon.com/paypage/PELYGQVJ8Q7IB/103-6821258-5919825

If you want to get the best response to a question, please read FAQ222-2244 first