Examples of complex.connectivity.hsqldb.TestCacheSize

complex.connectivity.hsqldb.TestCacheSize
Test large cached tables by setting up a cached table of 100000 records or more and a much smaller memory table with about 1/100th rows used. Populate both tables so that an indexed column of the cached table has a foreign key reference to the main table. This database can be used to demonstrate efficient queries to retrieve the data from the cached table. 1.7.1 insert timings for 100000 rows, cache scale 12: simple table, no extra index: 52 s with index on lastname only: 56 s with index on zip only: 211 s foreign key, referential_integrity true: 216 s The above have improved a lot in 1.7.2 This test now incorporates the defunct TestTextTables @author fredt@users @version 1.7.2 @since 1.7.0

                ,new com.sun.star.beans.PropertyValue("URL",0,mod.getURL(),PropertyState.DIRECT_VALUE)
            };        
            drv = (XDriver)UnoRuntime.queryInterface(XDriver.class,((XMultiServiceFactory)param.getMSF()).createInstance("com.sun.star.sdbcx.comp.hsqldb.Driver"));
        


            TestCacheSize test = new TestCacheSize(((XMultiServiceFactory)param.getMSF()),info,drv);


            StopWatch     sw   = new StopWatch();      


            try{
                test.setUp();
                test.testFillUp();
                test.checkResults();
                test.tearDown();
                System.out.println("Total Test Time: " + sw.elapsedTime());
            } catch(Exception e){}


            try{
                XStorable mod2 = (XStorable)UnoRuntime.queryInterface(XStorable.class,ds);

View Full Code Here

            info = new com.sun.star.beans.PropertyValue[]{
                new com.sun.star.beans.PropertyValue("JavaDriverClass",0,"org.hsqldb.jdbcDriver",PropertyState.DIRECT_VALUE)
                ,new com.sun.star.beans.PropertyValue("ParameterNameSubstitution",0, false,PropertyState.DIRECT_VALUE)
            };        
            drv = (XDriver)UnoRuntime.queryInterface(XDriver.class,((XMultiServiceFactory)param.getMSF()).createInstance("com.sun.star.comp.sdbc.JDBCDriver"));
            TestCacheSize test = new TestCacheSize(((XMultiServiceFactory)param.getMSF()),info,drv);
            test.setURL("jdbc:hsqldb:g:\\hsql\\db");




            StopWatch     sw   = new StopWatch();      


            try{
                test.setUp();
                test.testFillUp();
                test.checkResults();
                test.tearDown();
                System.out.println("Total Test Time: " + sw.elapsedTime());
            } catch(Exception e){}
        }catch(Exception e){}
    }

View Full Code Here

TOP

Related Classes of complex.connectivity.hsqldb.TestCacheSize

complex.connectivity.HsqlDriverTest

org.hsqldb.lib.StopWatch

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.