Examples with Index org.h2.index.Index used on opensource projects

Example 66 with Index

use of org.h2.index.Index in project h2database by h2database.

the class MVTable method addRowsToIndex.

private static void addRowsToIndex(Session session, ArrayList<Row> list, Index index) {
    sortRows(list, index);
    for (Row row : list) {
        index.add(session, row);
    }
    list.clear();
}

Example 67 with Index

use of org.h2.index.Index in project h2database by h2database.

the class MVTable method rebuildIndexBlockMerge.

private void rebuildIndexBlockMerge(Session session, MVIndex index) {
    if (index instanceof MVSpatialIndex) {
        // the spatial index doesn't support multi-way merge sort
        rebuildIndexBuffered(session, index);
    }
    // Read entries in memory, sort them, write to a new map (in sorted
    // order); repeat (using a new map for every block of 1 MB) until all
    // record are read. Merge all maps to the target (using merge sort;
    // duplicates are detected in the target). For randomly ordered data,
    // this should use relatively few write operations.
    // A possible optimization is: change the buffer size from "row count"
    // to "amount of memory", and buffer index keys instead of rows.
    Index scan = getScanIndex(session);
    long remaining = scan.getRowCount(session);
    long total = remaining;
    Cursor cursor = scan.find(session, null, null);
    long i = 0;
    Store store = session.getDatabase().getMvStore();
    int bufferSize = database.getMaxMemoryRows() / 2;
    ArrayList<Row> buffer = new ArrayList<>(bufferSize);
    String n = getName() + ":" + index.getName();
    int t = MathUtils.convertLongToInt(total);
    ArrayList<String> bufferNames = New.arrayList();
    while (cursor.next()) {
        Row row = cursor.get();
        buffer.add(row);
        database.setProgress(DatabaseEventListener.STATE_CREATE_INDEX, n, MathUtils.convertLongToInt(i++), t);
        if (buffer.size() >= bufferSize) {
            sortRows(buffer, index);
            String mapName = store.nextTemporaryMapName();
            index.addRowsToBuffer(buffer, mapName);
            bufferNames.add(mapName);
            buffer.clear();
        }
        remaining--;
    }
    sortRows(buffer, index);
    if (!bufferNames.isEmpty()) {
        String mapName = store.nextTemporaryMapName();
        index.addRowsToBuffer(buffer, mapName);
        bufferNames.add(mapName);
        buffer.clear();
        index.addBufferedRows(bufferNames);
    } else {
        addRowsToIndex(session, buffer, index);
    }
    if (SysProperties.CHECK && remaining != 0) {
        DbException.throwInternalError("rowcount remaining=" + remaining + " " + getName());
    }
}

Example 68 with Index

use of org.h2.index.Index in project h2database by h2database.

the class MVTable method removeChildrenAndResources.

@Override
public void removeChildrenAndResources(Session session) {
    if (containsLargeObject) {
        // unfortunately, the data is gone on rollback
        truncate(session);
        database.getLobStorage().removeAllForTable(getId());
        database.lockMeta(session);
    }
    database.getMvStore().removeTable(this);
    super.removeChildrenAndResources(session);
    // call table.removeIndex
    while (indexes.size() > 1) {
        Index index = indexes.get(1);
        if (index.getName() != null) {
            database.removeSchemaObject(session, index);
        }
        // needed for session temporary indexes
        indexes.remove(index);
    }
    if (SysProperties.CHECK) {
        for (SchemaObject obj : database.getAllSchemaObjects(DbObject.INDEX)) {
            Index index = (Index) obj;
            if (index.getTable() == this) {
                DbException.throwInternalError("index not dropped: " + index.getName());
            }
        }
    }
    primaryIndex.remove(session);
    database.removeMeta(session, getId());
    close(session);
    invalidate();
}

Example 69 with Index

use of org.h2.index.Index in project h2database by h2database.

the class MVTable method rebuildIndexBuffered.

private void rebuildIndexBuffered(Session session, Index index) {
    Index scan = getScanIndex(session);
    long remaining = scan.getRowCount(session);
    long total = remaining;
    Cursor cursor = scan.find(session, null, null);
    long i = 0;
    int bufferSize = (int) Math.min(total, database.getMaxMemoryRows());
    ArrayList<Row> buffer = new ArrayList<>(bufferSize);
    String n = getName() + ":" + index.getName();
    int t = MathUtils.convertLongToInt(total);
    while (cursor.next()) {
        Row row = cursor.get();
        buffer.add(row);
        database.setProgress(DatabaseEventListener.STATE_CREATE_INDEX, n, MathUtils.convertLongToInt(i++), t);
        if (buffer.size() >= bufferSize) {
            addRowsToIndex(session, buffer, index);
        }
        remaining--;
    }
    addRowsToIndex(session, buffer, index);
    if (SysProperties.CHECK && remaining != 0) {
        DbException.throwInternalError("rowcount remaining=" + remaining + " " + getName());
    }
}

Example 70 with Index

use of org.h2.index.Index in project h2database by h2database.

the class ResultTempTable method find.

private Cursor find(Row row) {
    if (index == null) {
        // for the case "in(select ...)", the query might
        // use an optimization and not create the index
        // up front
        createIndex();
    }
    Cursor cursor = index.find(session, row, row);
    while (cursor.next()) {
        SearchRow found = cursor.getSearchRow();
        boolean ok = true;
        Database db = session.getDatabase();
        for (int i = 0; i < row.getColumnCount(); i++) {
            if (!db.areEqual(row.getValue(i), found.getValue(i))) {
                ok = false;
                break;
            }
        }
        if (ok) {
            return cursor;
        }
    }
    return null;
}