Or write a script (e.g. Perl) to aggregate the data. This is what we do with our test runs (we use CSV output to make it a bit simpler)
It's probably not that difficult to write an XSL stylesheet to convert the XML to CSV or some other format to load into a database (if the database does not support XML input). Excel and probably other spreadsheets would be no use - 9M rows is too many. There may be some other analysis tools that can handle that many rows. S. On 7/6/05, Peter Lin <[EMAIL PROTECTED]> wrote: > keep in mind that all listeners will load the entire JTL file into > memory, so 9 million is just too much for JMeter. > > you might want to load the data into a database and then use SQL to > calculate the statistics. right now the listeners don't have the > ability to process the results in stream mode, so it's very easy to > hit the 2Gb ram limit of the 32bit JVM. > > > peter > > > On 7/6/05, Smits.Dolf <[EMAIL PROTECTED]> wrote: > > I was trying to read it into the aggregate report. > > > > Dolf > > > > -----Original Message----- > > From: Peter Lin [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, July 06, 2005 20:02 > > To: JMeter Users List > > Subject: Re: out of memory problems > > > > > > wow, 9 million results. the short answer is to split the file into > > smaller pieces. > > > > which listener are you trying to view the JTL log with? > > > > > > peter > > > > > > On 7/6/05, Smits.Dolf <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > > > I know this is a common problem, however it cannot be solved easily. > > > When I enlarge the heap size of java to large numbers (4096m) java won't > > > start anymore. > > > when it is set to about 1500m, i ran out of memory. > > > > > > I want to read a jtl file i created with a simple data writer in the > > > testplan. > > > the jtl contains about 9 million testresults. > > > > > > any hints how to handle this file, or another tool to analyze the results? > > > > > > Thanks, > > > > > > Dolf > > > > > > Dolf Smits > > > Senior Consultant Meta Directory Solutions > > > > > > Siemens Nederland N.V. > > > COM EN > > > > > > Bezoekadres > > > Prinses Beatrixlaan 800 > > > Den Haag > > > > > > Correspondentieadres > > > Postbus 16068 > > > NL-2500 BB Den Haag > > > > > > 070 333 3654 > > > 070 333 2511 > > > 06 55844837 > > > [EMAIL PROTECTED] > > > www.siemens.nl > > > > > > > > > > > > Deze e-mail is uitsluitend bedoeld voor kennisneming door de > > > geadresseerde(n), en mag niet aan anderen worden doorgestuurd of op andere > > > wijze ter kennis worden gebracht. Indien u niet de geadresseerde bent, > > > verzoek ik u om de afzender te waarschuwen en de e-mail direct te > > > verwijderen/vernietigen. De afzender wijst elke aansprakelijkheid voor (de > > > inhoud van) deze e-mail af. > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
