Changes between Version 110 and Version 111 of DatabaseBasedAnalysis


Ignore:
Timestamp:
09/02/18 19:32:51 (7 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis

    v110 v111  
    6161
    6262Some details about the contents and the meaning of the tables in the '''factdata''' database can be found here DatabaseBasedAnalysis/Tables.
     63
     64== Warning ==
     65
     66Be aware that a mysql database using the InnoDB engine is optimized to find data fast using an index. That means it can be very fast to select data and read the selected data. On the other hand, it is ''not'' optimized to read individual columns as for example the ''root'' file format. This a simple query, for example, to determine the minimum or maximum of a single column will read the whole table and is thus very resource intensive and slow! '''Think twice before you run a query!'''
    6367
    6468== The Analysis ==