|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
06-22-2014, 04:04 PM
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Oct 2003
Location: L.A.
Posts: 5,744
|
Never underestimate the power of a good index...
So I created a script to pull XML feeds from cam sites and I was appalled at the time it took them to grab the feeds... Like 4 minutes.
Then it occurred to me that I didn't have an index on my DB which was checking to see if the girls already existed before adding them. Bam... Just like that 20 seconds to run. 15 of which is spent downloading their slow ass feeds. index, index, index!
__________________
 Blog Posts - Contextual Links - Hardlinks on 600+ Blog Network * Handwritten * 180 C Class IPs * Permanent! * Many Niches! * Bulk Discounts! GFYPosts /at/ J2Media.net |
|
|
|
06-22-2014, 11:19 PM
|
#2 |
|
Confirmed User
Industry Role:
Join Date: Jan 2012
Location: NC
Posts: 7,683
|
happens to me all the time.
then i wonder why the fuck so many records, fuck me. so i truncate table , add index , and rerun.
__________________
SSD Cloud Server, VPS Server, Simple Cloud Hosting | DigitalOcean
|
|
|
|
