[TYPO3-mvc] speed improvements in own extbase extension

[Stefan Kruse]

Hi,

i have an extbase extension and it seems so i need speed improvements for this.

Here is what i done with the extension. 

Its a big searchform. There are companies and every company can have multiple categories assigned to. You can search for these categories and get all companies, or you can search directly for a company name. Ok, i try 2 ways. The first is: I have a m:m relation from the company to category. Thats works ok , but then we found out that we need some additional info for every assigned category. There should be a possibility to add a name and a phone number to every assigned category. Ok, that bring us to second way: I created a new model named listing. There are relations to category and company. And the additional properties name and phone. So every company can have multiple listings.

But when i search now for these listing then it takes a lot of time to get the results. In the database there are 200.000 entries.

I know its hard to understand maybe but i hope someone has a tip how i can make some speed improvements.

Thanks Stefan