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
Ryzen
(12 items)
 
  
CPUMotherboardGraphicsRAM
Ryzen 7 1700 Gigabyte GA-AB350M Gaming 3 Palit GT-430 Corsair Vengeance LPX CMK16GX4M2B3000C15 
Hard DriveCoolingOSMonitor
Samsung 850 EVO AMD Wraith Spire Linux Mint 18.x Dell UltraSharp U2414H 
KeyboardPowerCaseMouse
Apple Basic Keyboard Thermaltake ToughPower 850W Lian-Li PC-A04B Logitech Trackman Wheel 
  hide details  
Reply
Ryzen
(12 items)
 
  
CPUMotherboardGraphicsRAM
Ryzen 7 1700 Gigabyte GA-AB350M Gaming 3 Palit GT-430 Corsair Vengeance LPX CMK16GX4M2B3000C15 
Hard DriveCoolingOSMonitor
Samsung 850 EVO AMD Wraith Spire Linux Mint 18.x Dell UltraSharp U2414H 
KeyboardPowerCaseMouse
Apple Basic Keyboard 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.
Ryzen
(12 items)
 
  
CPUMotherboardGraphicsRAM
Ryzen 7 1700 Gigabyte GA-AB350M Gaming 3 Palit GT-430 Corsair Vengeance LPX CMK16GX4M2B3000C15 
Hard DriveCoolingOSMonitor
Samsung 850 EVO AMD Wraith Spire Linux Mint 18.x Dell UltraSharp U2414H 
KeyboardPowerCaseMouse
Apple Basic Keyboard Thermaltake ToughPower 850W Lian-Li PC-A04B Logitech Trackman Wheel 
  hide details  
Reply
Ryzen
(12 items)
 
  
CPUMotherboardGraphicsRAM
Ryzen 7 1700 Gigabyte GA-AB350M Gaming 3 Palit GT-430 Corsair Vengeance LPX CMK16GX4M2B3000C15 
Hard DriveCoolingOSMonitor
Samsung 850 EVO AMD Wraith Spire Linux Mint 18.x Dell UltraSharp U2414H 
KeyboardPowerCaseMouse
Apple Basic Keyboard 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