Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: Save record to BLOB

    Delphi
    by sx2008, 5. Dez 2009
  I've attached a small MS access database and a image with the relationship between the tables.
  You need some more tables and fields, but it could serve as a template.
• Forum: Datenbanken

  Re: Save record to BLOB

    Delphi
    by sx2008, 5. Dez 2009
  Let's asume you want to read all sensors from one monitor with the name "Test2009".
  Let's asume further there are 100 monitors and each monitor has 100 sensors.
  And everything is stored in one single BLOB.
  You have to read the BLOB on the whole and start a while-loop to find the monitor.
  This is really unefficient.
  You read a BLOB that could be huge only to use small parts of it.
  On a...
• Forum: Datenbanken

  Re: Save record to BLOB

    Delphi
    by sx2008, 5. Dez 2009
  Premature optimization is the root of all evil - Donald Knuth.
  read more: http://www.codinghorror.com/blog/archives/000061.html
  Maybe you save some time storing your data, but you lose very much time if you want to retrieve the data.
  Assume you want to read the data for a specific sensor and you know the name of the sensor.
  Doing it your way using BLOBs you have to read about 50% of all...