Register Log In

UBB.threads PHP Forum Software Community Forums Resources and Customizing How Do I? Large Table Insert in Steps?

Print Thread

Hop To

Re: Large Table Insert in Steps? SD #222101 02/08/2009 5:19 AM
Joined: Aug 2006 Posts: 1,360 Likes: 2 Utrecht, NL Y Yarp Veteran
Yarp Veteran Y Joined: Aug 2006 Posts: 1,360 Likes: 2 Utrecht, NL	In this case, how about rewriting your query... SQL Query INSERT INTO ubbt_NEW_TABLE(POST_ID) SELECT POST_ID FROM ubbt_POSTS that query took 0.2464 seconds to execute for about half a million posts. Does require mysql 4.1 or above.

Entire Thread
Subject	Posted By	Posted
Large Table Insert in Steps?	DLWebmaestro	02/08/2009 6:15 AM
Re: Large Table Insert in Steps?	SD	02/08/2009 7:18 AM
Re: Large Table Insert in Steps?	Yarp	02/08/2009 9:19 AM
Re: Large Table Insert in Steps?	DLWebmaestro	02/08/2009 5:41 PM
Re: Large Table Insert in Steps?	SD	02/08/2009 6:03 PM

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

Slow Queries - Any Ideas?
by BellaOnline - 10/16/2026 4:34 PM

Selling a Forum?
by ECNet - 10/10/2026 10:54 AM

UBB.threads 8.1 — a few questions before we plan our upgrade
by Geoff - 10/08/2026 2:06 PM

UBB.threads 8.1 — password_hash() / rehash-on-login planned?
by Geoff - 10/08/2026 1:57 PM

Prevent anonymous users from browsing old threads?
by sw55 - 08/11/2026 4:06 PM

Who's Online Now

1 members (1 invisible), 331 guests, and 94 robots.

Key: Admin, Global Mod, Mod

Random Gallery Image

Latest Gallery Images

Ride safe!

Ride safe!
by Morgan, December 7

Los Angeles

Los Angeles
by isaac, August 6

3D Creations

3D Creations
by JAISP, December 30

Artistic structures

Artistic structures
by isaac, August 29

Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)