This script is to initialize the db and test only once the CTE query. If you just do this with one user and no volume, the difference of performance is difficult to notice. You might notice something if your system is under heavy cpu or io load.
The measurement of CTE is done by the jmx file using jmeter and volume (200000 queries on a population using CSV parametrization). It's done on a db with data (from taxnum.csv). So if you just do the CTE once in a while you won't notice anything. There really is a difference of performance, you need statistical analysis with volume, hence the use of JMeter. Hope this clarifies. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
