[wp-hackers] set/modify the auto-incrementing ID of the wp_postmeta.
halukkaramete at gmail.com
Sat Aug 11 20:11:57 UTC 2012
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)
I find it difficult to believe.
How is it possible that a server can pull 12M records in 0.0003 sec?
Is this phpmyadmin data on how long the query tool reliable?
i'd like to hear your opinions on this.
On Sat, Aug 11, 2012 at 12:49 PM, Haluk Karamete
<halukkaramete at gmail.com> wrote:
> Wasn't there a trick to run the shell commands right from within a php
> page thru the use of a back tick char?
> would that do the trick of starting a php process from within a php
> page rather than going to the console and starting it manually?
> On Sat, Aug 11, 2012 at 8:49 AM, Dion Hulse (dd32) <wordpress at dd32.id.au> wrote:
>> Ah nice, I didn't realise that, I could've sworn although the default
>> is 0, that environments sharing php.ini between server and cli
>> contexts would use the php.ini setting.
>> Seems I'm mistaken :)
>> On 12 August 2012 01:19, Ryan McCue <lists at rotorised.com> wrote:
>>> Dion Hulse (dd32) wrote:
>>>> the most common method to resolve this is to run the script on the
>>>> command line, and use set_time_limit(0); (unlimited).
>>> If you're running it via the command line, the time limit should be set
>>> to unlimited automatically. (Unless WP sets it, but I can't recall it
>>> doing so.)
>>> Ryan McCue
>>> wp-hackers mailing list
>>> wp-hackers at lists.automattic.com
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
More information about the wp-hackers