Examples of org.hsqldb.rowio.RowOutputInterface

org.hsqldb.rowio.RowOutputInterface
Public interface for writing the data for a database row. @author Bob Preston (sqlbob@users dot sourceforge.net) @author Fred Toussi (fredt@users dot sourceforge.net) @version 1.9.0 @since 1.7.0


    int[] writeTableToDataFile(Table table) throws IOException {


        Session session = database.getSessionManager().getSysSession();
        PersistentStore    store  = session.sessionData.getRowStore(table);
        RowOutputInterface rowOut = cache.rowOut.duplicate();
        DoubleIntIndex pointerLookup = new DoubleIntIndex(
            ((IndexAVL) table.getPrimaryIndex()).sizeEstimate(store), false);
        int[] rootsArray = table.getIndexRootsArray();
        long  pos        = fileOffset;
        int   count      = 0;


        pointerLookup.setKeysSearchTarget();
        Error.printSystemOut("lookup begins: " + stopw.elapsedTime());


        // all rows
        RowIterator it = table.rowIterator(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            pointerLookup.addUnsorted(row.getPos(), (int) (pos / scale));


            if (count % 50000 == 0) {
                Error.printSystemOut("pointer pair for row " + count + " "
                                     + row.getPos() + " " + pos);
            }


            pos += row.getStorageSize();
        }


        Error.printSystemOut("table: " + table.getName().name + " list done: "
                             + stopw.elapsedTime());


        count = 0;
        it    = table.rowIterator(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            rowOut.reset();
            row.write(rowOut, pointerLookup);
            fileStreamOut.write(rowOut.getOutputStream().getBuffer(), 0,
                                rowOut.size());


            fileOffset += row.getStorageSize();


            if ((count) % 50000 == 0) {
                Error.printSystemOut(count + " rows " + stopw.elapsedTime());

View Full Code Here


    long[] writeTableToDataFile(Table table) throws IOException {


        Session session = database.getSessionManager().getSysSession();
        PersistentStore    store      = table.getRowStore(session);
        RowOutputInterface rowOut     = dataCache.rowOut.duplicate();
        long[]             rootsArray = table.getIndexRootsArray();
        long               pos        = fileOffset;
        long               count      = 0;


        pointerLookup.removeAll();
        pointerLookup.setKeysSearchTarget();
        database.logger.logDetailEvent("lookup begins " + table.getName().name
                                       + " " + stopw.elapsedTime());


        // all rows
        RowIterator it = table.rowIteratorClustered(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            pointerLookup.addUnsorted((int) row.getPos(), (int) (pos / scale));


            if (count != 0 && count % 100000 == 0) {
                database.logger.logDetailEvent("pointer pair for row " + count
                                               + " " + row.getPos() + " "
                                               + pos);
            }


            pos += row.getStorageSize();
        }


        database.logger.logDetailEvent("table read " + table.getName().name
                                       + " " + stopw.elapsedTime());


        count = 0;
        it    = table.rowIteratorClustered(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            rowOut.reset();
            row.write(rowOut, pointerLookup);
            randomAccessOut.write(rowOut.getOutputStream().getBuffer(), 0,
                                  rowOut.size());


            fileOffset += row.getStorageSize();


            if (count != 0 && count % 100000 == 0) {
                database.logger.logDetailEvent("rows count " + count + " "

View Full Code Here


    int[] writeTableToDataFile(Table table) throws IOException {


        Session session = database.getSessionManager().getSysSession();
        PersistentStore    store      = table.getRowStore(session);
        RowOutputInterface rowOut     = cache.rowOut.duplicate();
        int[]              rootsArray = table.getIndexRootsArray();
        long               pos        = fileOffset;
        int                count      = 0;


        pointerLookup.removeAll();
        pointerLookup.setKeysSearchTarget();
        database.logger.logDetailEvent("lookup begins " + table.getName().name
                                       + " " + stopw.elapsedTime());


        // all rows
        RowIterator it = table.rowIteratorClustered(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            pointerLookup.addUnsorted(row.getPos(), (int) (pos / scale));


            if (count != 0 && count % 100000 == 0) {
                database.logger.logDetailEvent("pointer pair for row " + count
                                               + " " + row.getPos() + " "
                                               + pos);
            }


            pos += row.getStorageSize();
        }


        database.logger.logDetailEvent("table read " + table.getName().name
                                       + " " + stopw.elapsedTime());


        count = 0;
        it    = table.rowIteratorClustered(store);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            rowOut.reset();
            row.write(rowOut, pointerLookup);
            randomAccessOut.write(rowOut.getOutputStream().getBuffer(), 0,
                                  rowOut.size());


            fileOffset += row.getStorageSize();


            if (count != 0 && count % 100000 == 0) {
                database.logger.logDetailEvent("rows count " + count + " "

View Full Code Here


    int[] writeTableToDataFile(Table table) throws IOException {


        Session session = database.getSessionManager().getSysSession();
        PersistentStore    store  = session.sessionData.getRowStore(table);
        RowOutputInterface rowOut = new RowOutputBinary();
        DoubleIntIndex pointerLookup =
            new DoubleIntIndex(table.getPrimaryIndex().sizeEstimate(store),
                               false);
        int[] rootsArray = table.getIndexRootsArray();
        long  pos        = fileOffset;
        int   count      = 0;


        pointerLookup.setKeysSearchTarget();
        Error.printSystemOut("lookup begins: " + stopw.elapsedTime());


        RowIterator it = table.rowIterator(session);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            pointerLookup.addUnsorted(row.getPos(), (int) (pos / scale));


            if (count % 50000 == 0) {
                Error.printSystemOut("pointer pair for row " + count + " "
                                     + row.getPos() + " " + pos);
            }


            pos += row.getStorageSize();
        }


        Error.printSystemOut(table.getName().name + " list done ",
                             stopw.elapsedTime());


        count = 0;
        it    = table.rowIterator(session);


        for (; it.hasNext(); count++) {
            CachedObject row = it.getNextRow();


            rowOut.reset();
            row.write(rowOut, pointerLookup);
            fileStreamOut.write(rowOut.getOutputStream().getBuffer(), 0,
                                rowOut.size());


            fileOffset += row.getStorageSize();


            if ((count) % 50000 == 0) {
                Error.printSystemOut(count + " rows " + stopw.elapsedTime());

View Full Code Here

TOP

Related Classes of org.hsqldb.rowio.RowOutputInterface

org.hsqldb.persist.DataFileDefrag

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.