[Typo3-dev] RealURL : high server load and optimization

[Brice Bernard]

I have a website storing hundreds of pages, the problem comes from
realurl extension and sql querie optimization.
My table 'tx_realurl_uniqalias' stores 100 000 records and queries to
render the page is like this :

SELECT value_id
FROM tx_realurl_uniqalias
WHERE
value_alias="my-page"
AND field_alias="title"
AND field_id="uid"
AND tablename="tx_myextension"

SELECT value_alias
FROM tx_realurl_uniqalias
WHERE
value_id="89031"
AND field_alias="title"
AND field_id="uid"
AND tablename="tx_myextension"

Because of these queries, page generation can take up to 120 second!!!
(about 1 or 2 seconds per request).

Does anyone ever face this kind of problem and knows how to solve it?