Inserting Symfony NestedSet data via MySQL queries

Question

On a Symfony exploration project, I have a model using doctrine NestedSet behaviour. Since the data is prepared in a flat file, I wrote a conversion utility to generate corresponding YAML. It turns out that processing NestedSet YML of around 100 records (max_depth=4) consumes over 40MB of PHP memory, which is not available to me.

Is there a work-around to this problem?

I'm thinking of 2 possible solutions.

Write an equivalent PHP script to populate objects & save them
Insert data via SQL statements, the challenge being to compute the left & right nodes

What do Symfonians suggest?

Pre-order travel algo explained: sitepoint.com/hierarchical-data-database-2 — Prasad
– Prasad, Commented Nov 30, 2011 at 7:36
It has the foll fields: level, id, name, parent_id. So if fruit is a child of food, then the CSV data has 2 lines: 1=>[0, f1, Food, ] 2=>[1, f2, Fruit, f1] — Prasad
– Prasad, Commented Dec 2, 2011 at 10:54

greg0ire · Accepted Answer · 2011-12-02 11:06:46Z

1

I suggest you insert the data in several times, one time per level starting at level 0, for instance.

answered Dec 2, 2011 at 11:06

greg0ire

23.3k17 gold badges76 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Prasad · Accepted Answer · 2012-05-25 13:47:49Z

0

Option 2 was better.

I wrote a simple macro in Excel to compute the lgt and rgt values required for the pre-order tree. Logic as mentioned here: http://www.sitepoint.com/hierarchical-data-database-2/ The same Excel utility would convert values to a SQL query that could be dumped via file.

Going through the fixtures/object route exceeded the allowed memory limit.

answered May 25, 2012 at 13:47

Prasad

1,8203 gold badges23 silver badges41 bronze badges

Collectives™ on Stack Overflow

Inserting Symfony NestedSet data via MySQL queries

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related