I have a problem with a query that I want to generate and that includes
three tables, two of which contain about 40,000 records, the third
about 200,000 records.
When I first call relate4Top on a Windows XP machine it takes about 150
seconds(!) to generate the query with a result set of about 300
records. Future calls are much faster at about 4 seconds.
I am using memory optimization and (to a little extend) query
optimization.
Can anyone give me a hint how I can speed up the first call of the
query?
Markus
