[TYPO3-mvc] DataMapper performance issue.

[Braulio José Solano Rojas]

Hello.

I've been having performance issues with one app made on extbase.  I just ran a profiling and I see that DataMapper and QueryResult consume a lot of resources.  Here is some data:

+--------------------------------------------------------------------+-----------+-----------+-------------+-------------+--------+

| Function                                                           | Avg. Self | Avg. Cum. |  Total self |  Total Cum. |  Calls |

+--------------------------------------------------------------------+-----------+-----------+-------------+-------------+--------+

| Tx_Extbase_Persistence_Mapper_DataMapper->thawProperties           |     3,5ms |   1.882ms |     8.975ms | 4.767.962ms |  2.534 |

| Tx_Extbase_Persistence_QueryResult->getFirst                       |     0,5ms |   1.298ms |       446ms | 1.229.391ms |    947 |

| Tx_Extbase_Persistence_Mapper_DataMapper->map                      |     0,2ms |   1.201ms |       791ms | 4.780.793ms |  3.980 |

| Tx_Extbase_Persistence_QueryResult->rewind                         |     0,1ms |   1.183ms |       355ms | 3.587.500ms |  3.033 |

| Tx_Extbase_Persistence_Mapper_DataMapper->mapResultToPropertyValue |     1,0ms |   1.046ms |     4.639ms | 4.656.382ms |  4.452 |

| Tx_Extbase_Persistence_QueryResult->current                        |     920ms |     920ms | 4.294.418ms | 4.294.654ms |  4.666 |

| Tx_Extbase_Persistence_Mapper_DataMapper->mapSingleRow             |     0,4ms |     851ms |     2.284ms | 4.778.574ms |  5.613 |

| Tx_Extbase_Persistence_QueryResult->initialize                     |         - |     179ms |     1.581ms | 3.587.973ms | 20.064 |

+--------------------------------------------------------------------+-----------+-----------+-------------+-------------+--------+

The call tree is incredibly deep.

I do not understand what's happening, my queries are really dumb.

Has someone had the same troubles?

I am using TYPO3 4.5.2 and extbase 1.3.0.

I would appreciate any hints.

Best regards,

B.


-- 
Director General
Solsoft de Costa Rica
Inteligencia Artificial... en su Negocio
http://solsoft.biz/
http://www.facebook.com/solsoft
http://www.linkedin.com/company/solsoft-de-costa-rica-s.a./

"The two parties which divide the State, the party of Conservatism and that of Innovation are very old, and have disputed the possession of the world ever since it was made ... Now one, now the other gets the day, and still the fight renews itself as if for the first time, under new names and hot personalities ... Innovation is the salient energy; Conservatism the pause on the last movement."

Ralph Waldo Emerson