Extensible Storage Engine - Comparison To JET Red

Comparison To JET Red

While they share a common lineage, there are vast differences between JET Red and ESE.

  • JET Red is a file sharing technology, while ESE is designed to be embedded in a server application, and does not share files.
  • JET Red makes best effort file recovery, while ESE has write ahead logging and snapshot isolation for guaranteed crash recovery.
  • JET Red before version 4.0 supports only page level locking, while ESE and JET Red version 4.0 supports record level locking.
  • JET Red supports a wide variety of query interfaces, including ODBC and OLE DB. ESE does not ship with a query engine but instead relies on applications to write their own queries as C ISAM code.
  • JET Red has a maximum database file size of 2 GiB, while ESE has a maximum database file size of 8 TiB with 4 KiB pages, and 16 TiB with 8 KiB pages.

Read more about this topic:  Extensible Storage Engine

Famous quotes containing the words comparison to, comparison, jet and/or red:

    It is very important not to become hard. The artist must always have one skin too few in comparison to other people, so you feel the slightest wind.
    Shusha Guppy (b. 1938)

    Intolerance respecting other people’s religion is toleration itself in comparison with intolerance respecting other people’s art.
    Wallace Stevens (1879–1955)

    I cannot beat off
    Invincible modes of the sea, hearing:
    Be a man my son by God.
    He turned again
    To the purring jet yellowing the murder story,
    Deaf to the pathos circling in the air.
    Allen Tate (1899–1979)

    O My Luve’s like a red, red rose,
    That’s newly sprung in June;
    O My Luve’s like the melodie
    That’s sweetly played in tune.
    Robert Burns (1759–1796)