[wp-hackers] set/modify the auto-incrementing ID of the wp_postmeta.

Scott Taylor scott.c.taylor at mac.com
Sat Aug 11 20:19:31 UTC 2012


to test actual use cases:

1) query records by post_id or meta_key, both have indexes
2) JOIN posts and post_meta and compare meta_values (unindexed, sorts on disk, slow)


-- 
scott taylor
musician / software engineer
160 west end ave #2H 
new york, ny 10023
m 646.715.7347
twitter: wonderboymusic
web: scotty-t.com


On Saturday, August 11, 2012 at 4:14 PM, Daryl L. L. Houston wrote:

> On Saturday, August 11, 2012 at 4:11 PM, Haluk Karamete wrote:
> > PHPmyadmin query results.. I'm not done yet, ( the goal is 70M recs,
> > now it's around 13M)
> > but I wanted to share the results...
> > 
> > SELECT * FROM `wp_postmeta` LIMIT 0 , 30
> > Showing rows 0 - 29 (~12,896,9541 total, Query took 0.0003 sec)
> > 
> 
> 
> 
> It pulled only 30 records. Much more believable. :) 
> 
> Daryl
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com (mailto:wp-hackers at lists.automattic.com)
> http://lists.automattic.com/mailman/listinfo/wp-hackers
> 
> 




More information about the wp-hackers mailing list