Originally posted by Ernest Lee:
Please tell us more about the purpose of your application.
Please forgive me for the missing informations. The application consists of several servlets which on user request produce dynamic SQL queries. These queries can
return from 0 to more than 100000 records. The results are shown to the user by a pagination in the memory.
The ResultSet reading, which follows more or less the scheme that I described in the previous mail, produces the application crashing when the two nested cycles are very long. I made a kind of optimization, managing on my best the local objects creation and the Vector presizing, but actually I can't understand if the problem is the memory size or if it depends on other factors as for example the RecordSet reading.
Any suggestion will be pleasant. Thank you.
Best Wishes.