Store Files in Database
Dear Community,
i store at the moment file "binary blob" in my database. If i store a lot of files and bigger files (like 80MB per file), the database speed / table speed slow down very much.
what can i do?
here is my.ini
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
basedir=C:\Program Files (x86)\MySQL\MySQL Server 5.5\
datadir=D:\MySQL\Data
key_buffer_size=512M
read_buffer_size=8M
read_rnd_buffer_size=32M
bulk_insert_buffer_size=512M
character-set-server=latin1
default-storage-engine=myisam
sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=250
skip-innodb=1
tmp_table_size=195M
table_cache=256
query_cache_size=0
thread_cache_size=8
myisam_max_sort_file_size=10G
myisam_sort_buffer_size=389M
sort_buffer_size=2M
myisam_repair_threads=1
myisam_recover=1
max_allowed_packet=256M
And a Layout from the Table
MyCommand.CommandText = "CREATE TABLE `mydb`.`files` (`Index` INT NOT NULL AUTO_INCREMENT , `FileNr` INT NULL , `PatNr` INT NULL , `Datum` DATE NULL , `Beschreibung` VARCHAR(255) NULL , `Notiz` MEDIUMTEXT NULL , `BinFile` LONGBLOB NULL , `File_Size` TEXT NULL , `OFile_Size` TEXT NULL , `TresorFile` LONGBLOB NULL , `Tresor_File_Size` TEXT NULL , `Tresor_OFile_Size` TEXT NULL , `SigData` TEXT NULL , `VideoFile` LONGBLOB NULL , `Video_File_Size` TEXT NULL , `Rechte` TEXT NULL , `Mandant` VARCHAR(45) NULL , `Bildnamen` TEXT NULL , `VideoSequenzen` INT NULL , `Uhrzeit` TIME NULL , `Ausgelagert` VARCHAR(255) NULL , `Flag` VARCHAR(45) NULL , PRIMARY KEY (`Index`) );"