Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pollaeng
Starting Member
1 Post |
 Posted - 2004-06-30 : 21:39:10
|
Hi are there any limitations on the record enters per hour in the SQL server.Thanks in advance |
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2004-06-30 : 21:44:05
|
| The only limitation is in the hardware.If your hardware can cope, sql can cope |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-06-30 : 21:46:59
|
| I believe those sort of limitations are based on your hardware and the size of the records in questions. Smaller rows (fewer columns, less bytes) will insert faster than larger rows. Also, the indexes you have on the table in question will slow down inserts. Depending on the items above, you should be able to do upwards of 50-100 records/second. If you have small rows and fast hardware, you can do many many more than that.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
Aamir
Starting Member
14 Posts |
Posted - 2004-07-01 : 04:23:29
|
| Hi, The limitation purely base upon the no. of records, no. of fields in processing, table constraints and the hardware.SoftGuru |
|
|
|
|
|
|
limitations