View Single Post
  #5  
Old 23rd Mar 04, 05:44 PM
SlickVic78's Avatar
SlickVic78 SlickVic78 is offline
Senior Member
 
Join Date: Sep 2001
Location: New York, USA
Posts: 515
SlickVic78 is an unknown quantity at this point
JacKDynne,

That helps out ALOT! A Delayed Insert can be useful if you have a very busy site where users are accessing the tables frequently... I guess as soon as no tables are being accessed within the DB, that is when the process kicks off to insert/update/replace the information within the specified tables. But the flaw is if MySQL gets killed in the process of the update, you lose that data that was not yet placed within the DB. Makes sense!

Thanks for the help. I pretty much assume I now know the roles of "Insert", "Update", and "Replace".

Insert - places infomation specifies within a new row within a table
Update - checks to see if rows are identicle, if not update the row with the new info
Replace - replace a row with new info

If I am wrong, someone please correct me.

Again, thanks for all your help in helping me understand all this DB jargon!

-SlickVic78
__________________
  • Pentium 4 3.20GHz Processor
  • 1 Gig DDR 400MHz RAM
  • 100 Gig 7200 RPM Western Digital HDD
  • 80 Gig 7200 RPM Western Digital HDD
  • Lite-On LTR-52327S CD-RW Burner
  • Lite-On SOHW-1633S DVD Burner
  • ATI Radeon 9700 Pro
  • Sound Blaster Audigy
  • Microsoft Windows XP Pro SP-2
Reply With Quote