Click here to Skip to main content
15,848,558 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Advice needed [modified] Pin
Pete O'Hanlon23-Jul-08 9:59
subeditorPete O'Hanlon23-Jul-08 9:59 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 10:26
Graham Bradshaw23-Jul-08 10:26 
GeneralRe: SQL Advice needed Pin
Daniel Turini23-Jul-08 10:35
Daniel Turini23-Jul-08 10:35 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 10:41
Graham Bradshaw23-Jul-08 10:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 10:49
StevenWalsh23-Jul-08 10:49 
GeneralRe: SQL Advice needed Pin
Pete O'Hanlon23-Jul-08 10:52
subeditorPete O'Hanlon23-Jul-08 10:52 
GeneralRe: SQL Advice needed Pin
GuyThiebaut23-Jul-08 11:28
professionalGuyThiebaut23-Jul-08 11:28 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 3:41
SomeGuyThatIsMe24-Jul-08 3:41 
depending on the db used, and how you set it up it may have to grow itself to be able to store that data i.e. if you origionally set up the db for 3gb, and its taking up all 3 or has gotten bigger, any time you insert you'll have to wait on the database to go find another contiguous section of disc to put the new data on. on sql server 2k you can set the inital size and the growth rate as a percentage or fixed amount, we have a 1tb raid array so we can let it grow 1gb at a time, which lets it work for a while without needing new space. we also created the db several times larger than it was when we built the server, so it wouldnt need to grow for a long time. Contiguous disk space is your friend for data heavy applications, because if you can put all a table or tables together it will reduce seek time. also disabling the log file or setting the log file up to have a large amount of space could help too, if its logging the inserts then that file will get pretty big and have to go find more space for itself.

i've greatly sped up our db server and other databases by forcing it to clear the log file, and giving it quite abit of space for it since we regularly upload (insert, delete, update) over 500 million rows in a handful of tables. we upload them to a temp database on the main server then do compares to deteremin what needs to be added removed or changed, then run those queries, so we arent adding 500 million rows every few months, but we do have to mess with that much data, the inserts are ususally only 20 or 30 million, but it does run fairly fast(20 to 30 minutes at most including initial upload done with bcp) on the new machine. top end dell 5u 15k rpm sata2 drives..its sweet.

hopefully this was somewhat helpful

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

GeneralRe: SQL Advice needed Pin
StevenWalsh24-Jul-08 5:40
StevenWalsh24-Jul-08 5:40 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 5:47
SomeGuyThatIsMe24-Jul-08 5:47 
QuestionCreating Reports using DataSet Pin
Reality Strikes23-Jul-08 6:19
Reality Strikes23-Jul-08 6:19 
AnswerRe: Creating Reports using DataSet Pin
Wendelius23-Jul-08 7:20
mentorWendelius23-Jul-08 7:20 
GeneralRe: Creating Reports using DataSet Pin
Verghese25-Jul-08 5:57
Verghese25-Jul-08 5:57 
GeneralRe: Creating Reports using DataSet Pin
Wendelius25-Jul-08 10:37
mentorWendelius25-Jul-08 10:37 
QuestionSELECT command Pin
Reality Strikes23-Jul-08 5:33
Reality Strikes23-Jul-08 5:33 
AnswerRe: SELECT command Pin
Harvey Saayman23-Jul-08 5:46
Harvey Saayman23-Jul-08 5:46 
GeneralRe: SELECT command Pin
Reality Strikes23-Jul-08 6:00
Reality Strikes23-Jul-08 6:00 
GeneralRe: SELECT command Pin
Harvey Saayman23-Jul-08 6:57
Harvey Saayman23-Jul-08 6:57 
QuestionAttaching database Pin
hadad22-Jul-08 22:37
hadad22-Jul-08 22:37 
AnswerRe: Attaching database Pin
Colin Angus Mackay23-Jul-08 4:34
Colin Angus Mackay23-Jul-08 4:34 
AnswerRe: Attaching database Pin
Vimalsoft(Pty) Ltd23-Jul-08 6:58
professionalVimalsoft(Pty) Ltd23-Jul-08 6:58 
Questionsql server data transferring?? Pin
Dotnetkanna22-Jul-08 22:34
Dotnetkanna22-Jul-08 22:34 
QuestionMultiple processes with the same ID Pin
JacquesDP22-Jul-08 22:05
JacquesDP22-Jul-08 22:05 
AnswerRe: Multiple processes with the same ID Pin
Wendelius23-Jul-08 7:03
mentorWendelius23-Jul-08 7:03 
QuestionRe: Multiple processes with the same ID Pin
JacquesDP23-Jul-08 19:18
JacquesDP23-Jul-08 19:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.