[support] Problem quickly deleting 90,000 product nodes

[Don]

That's a really great idea. By running it as a php script I can get 
around the apache memory limitations as well.
Thanks.

-Don-
dpickerel
On 10/29/2010 1:51 PM, Ted wrote:
>
> You might also consider doing it with drush, e.g.
>
> $ drush php-script delete_my_nodes
>
> ...where delete_my_nodes.php contains a query to get the node ids to 
> delete, and a loop to node_delete each one.
>
> Ted
>
> On 10/29/2010 1:43 PM, Don wrote:
>> Thanks for the reply Brian. I'd thought of looking up the setting for 
>> content administration but not for vbo.
>> I switched it to batch mode and then back, and it worked in short 
>> bursts of partial lists. Neither of the modules recommended were 
>> ready for that many nodes. I was getting a lot of out of memory 
>> errors last night in the mysql include. I'll look into debugging when 
>> I get some time.  I've worked with vbo before and I'm pretty familiar 
>> with its internals.
>>
>> -Don-
>> dpickerel
>>
>> On 10/29/2010 1:19 PM, Brian Choc wrote:
>>> Tried changing the number of items per page?
>>>
>>>
>>>
>>> On Thu, Oct 28, 2010 at 7:08 PM, Don <donald at fane.com 
>>> <mailto:donald at fane.com>> wrote:
>>>
>>>     I have VBO installed and went to admin/content/node2. I filtered
>>>     on the node type and came up with 97,000 nodes. I set it to
>>>     delete node, and there's a button next to the "All *20* rows in
>>>     this page are selected." text that says "Select all 99,000 rows
>>>     in this view", but when I click it nothing happens. The most I
>>>     can delete is 20 rows at a time.
>>>
>>>     I'm guessing it's a configuration setting or something similar,
>>>     but I have no clue. I'm logged in as user 1. There are no
>>>     javascript errors and I've tried it in FF and IE8.
>>>     Any suggestions?
>>>
>>>     Thanks.
>>>     -Don-
>>>
>>>     On 10/28/2010 2:08 AM, sivaji j.g wrote:
>>>>
>>>>
>>>>     On Thu, Oct 28, 2010 at 6:33 AM, Don <donald at fane.com
>>>>     <mailto:donald at fane.com>> wrote:
>>>>
>>>>         I have an ubercart ecommerce customer with over 100,000
>>>>         products in
>>>>         their database.
>>>>         For testing, I need to quickly delete about 95,000 of them.
>>>>         Node, uc_product, etc..
>>>>
>>>>
>>>>         Drupal 6.x
>>>>         Any good ideas?
>>>>
>>>>
>>>>     views bulk operation
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>     -- 
>>>>     Sivaji
>>>>     +91 9941 571 690
>>>>
>>>>
>>>
>>>
>>>     --
>>>     [ Drupal support list | http://lists.drupal.org/ ]
>>>
>>>
>>>
>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20101029/4e043010/attachment.html