Views : 286 Clicks : 17

Updating big tables using a temp table

By djamma via echodevil.com
Submitted On September 9, 2010

If you are in a situation where you have to insert a very large number of records into one table (with indexes on it) it may very well have occurred to you that such inserts take forever. To descrease the time usage we suggest 2 methods: A temp table or a table rename flow.

  0 Comments   Tags: Tutorials,  Methodologies,  Database,  Others

Freshly Arrived

1. How to Build Your Email Marketing List with a WordPress Website
2. An Overview of JavaScript Operators
3. Working with indexes in databases for beginners
4. Which of These 5 XML Tactics is Missing From Your E-Commerce?
5. HTML5 Security Isn’t

Getting Hotter