Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Application Programming › Mobile AppStore - Filesystem Or Database
New Posts  All Forums:Forum Nav:

Mobile AppStore - Filesystem Or Database

post #1 of 4
Thread Starter 
I have a requirement from a customer to deliver a bespoke enterprise Android mobile app store. My question is this: for delivering the APKs, which would perform better, the filesystem (ext4 on Ubuntu Server) or a relational database like MySQL or Oracle? The APKs will typically be less than 1MB in size, and the app store itself will have to support up to 10,000 users.

Many thanks. smile.gif
Mythica
(14 items)
 
  
CPUMotherboardGraphicsRAM
Intel i3 530 Gigabyte GA-H55M-D2H Palit nVidia GT430 Corsair Dominator 4GB TW3X4G1333C9A 
Hard DriveHard DriveOSMonitor
Western Digital Scorpio Black Samsung HD204UI Linux Mint 17 HP L1800 
KeyboardPowerCaseMouse
Logitech Basic Thermaltake ToughPower 850W Lian-Li PC-A04B Logitech Trackman Wheel 
  hide details  
Reply
Mythica
(14 items)
 
  
CPUMotherboardGraphicsRAM
Intel i3 530 Gigabyte GA-H55M-D2H Palit nVidia GT430 Corsair Dominator 4GB TW3X4G1333C9A 
Hard DriveHard DriveOSMonitor
Western Digital Scorpio Black Samsung HD204UI Linux Mint 17 HP L1800 
KeyboardPowerCaseMouse
Logitech Basic Thermaltake ToughPower 850W Lian-Li PC-A04B Logitech Trackman Wheel 
  hide details  
Reply
post #2 of 4
Quote:
Originally Posted by parityboy View Post

I have a requirement from a customer to deliver a bespoke enterprise Android mobile app store. My question is this: for delivering the APKs, which would perform better, the filesystem (ext4 on Ubuntu Server) or a relational database like MySQL or Oracle? The APKs will typically be less than 1MB in size, and the app store itself will have to support up to 10,000 users.

Many thanks. smile.gif

Both. You'd need the metadata and properties in the database, but reading the APKs from disk would be fine.
post #3 of 4
Thread Starter 
@Plan9

That's what I'm doing now with another server application, and it seems to be fine. However, I know people do serve up binaries from databases in certain circumstances, although I suppose in this case there's no advantage to processing an extra SQL query to pull an APK.
Mythica
(14 items)
 
  
CPUMotherboardGraphicsRAM
Intel i3 530 Gigabyte GA-H55M-D2H Palit nVidia GT430 Corsair Dominator 4GB TW3X4G1333C9A 
Hard DriveHard DriveOSMonitor
Western Digital Scorpio Black Samsung HD204UI Linux Mint 17 HP L1800 
KeyboardPowerCaseMouse
Logitech Basic Thermaltake ToughPower 850W Lian-Li PC-A04B Logitech Trackman Wheel 
  hide details  
Reply
Mythica
(14 items)
 
  
CPUMotherboardGraphicsRAM
Intel i3 530 Gigabyte GA-H55M-D2H Palit nVidia GT430 Corsair Dominator 4GB TW3X4G1333C9A 
Hard DriveHard DriveOSMonitor
Western Digital Scorpio Black Samsung HD204UI Linux Mint 17 HP L1800 
KeyboardPowerCaseMouse
Logitech Basic Thermaltake ToughPower 850W Lian-Li PC-A04B Logitech Trackman Wheel 
  hide details  
Reply
post #4 of 4
I stumbled across this Stack Exchange post which answers your question very well:
http://dba.stackexchange.com/questions/2445/files-in-the-database-or-not
Edited by Plan9 - 10/7/13 at 2:25am
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Application Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Application Programming › Mobile AppStore - Filesystem Or Database