Data Base - Storage Device Type

[MMARI.1]

hi,

I need to make a database storage ( 20GB ) place using FatFs So,  stored data's  will be retained from the storage place and stored data's  will come to display when necessary . 

1. Full Speed USB Flash Drive as Storage - Decent Speed but most of the USB Flash Drive are getting Hot for long time in PC . I didn't tested hotness of USB Flash Drive plugged with stm32 for 24 hours . it's really worth consider the USB Flash Drive as Storage based on the failure circumstance .in case if i choose the USB HDD based SSD or NVMe as Storage  then Size too big and cost . There is any rugged USB Flash Drive ?.

2. SD Card as Storage -   SD card life is unpredictable  .

3. eMMC as Storage (i don't have  Experience using eMMC)  - will stm32 mcu  support in eMMC 4 bit mode as sd card using FatFs ? and Not interest for 8 bit mode eMMC since many works involved  for using FatFs or little FatFs.

who will be runner up for speed and life of storage device ?   with following combination.

stm32 + USB Flash Drive ( Pendrive ) .

stm32 + USB HDD based on SSD or NVMe as Storage .

stm32 + eMMC ( 4bit Mode SD Card Mode  ) .

Please share your technical tips and suggestion .

[Andrew Neil]

---

@MMARI.1 wrote:

most of the USB Flash Drive are getting Hot for long time in PC

---

Are you sure that's due to the drive itself? Could well be heating from the PC ...

---

@MMARI.1 wrote:

SD card life is unpredictable  .

---

Is it?  I don't think that SD-Cards are inherently any more nor less "reliable" than comparable USB sticks?

---

@MMARI.1 wrote:

There is any rugged USB Flash Drive ?.

---

What, exactly, do you mean by "rugged" ?

maybe try 

https://nexusindustrialmemory.com/

https://www.simms.co.uk/

https://shop.sandisk.com/products/memory-cards/microsd-cards/industrial-microsd?sku=SDSDQAF3-008G-I

https://shop.sandisk.com/products/embedded-flash/industrial-inand-emmc-drives?sku=SDINBDG4-8G-I2

[MMARI.1]

Hi Neil,

Do you think using Portable  HDD ( SSD based)  +  USB high speed driver  + stm32 mcu will give the best data transfer  rate? .

[Tesla DeLorean]

FATFS will work with whatever you implement in the DISKIO layer

I'd use current version of FATFS, not the one from 2017. Efficiency/speed will come from using large aligned blocks, spanning multiple sectors, ideally cluster sizes, or 32KB, or whatever you can accomodate. Doing many small transactions at an application level will kill speed.

[MMARI.1]

hi,

Database look like this .

single folder maximum size will be  3MB (mega byte) and most of the time folder size will be  less than 3MB. Day wise folder will be called  one by one to Display Buffer. 

Still i am not come to the conclusion to use USB based HDD or SDMMC based eMMC !.

Theoretically going through to both memory device with following consideration .

1. Long Life  2. Stability ( No frequent crash ) 3. Speed .

 FatFs SFN  vs FatFs LFN  will make impact on Speed ?.

How much industrial SDMMC card is good in 1. Long Life  2. Stability ( No frequent crash ) 3. Speed compared to micro SD card . Since this Card has been used in Camera .

For eMMC below link case study will be useful .

https://community.st.com/t5/stm32-mcus-embedded-software/stm32h7-with-fatfs-on-emmc-sometimes-failing/m-p/632609#M44824

FatFs 32bit  vs FatFs 64 bit 

if you have any technical suggestion (or) tips are most welcome on this subject .