-1

I am working on project that require storing large data in tables in smartphone within the application. I already searched through google about this topic but did not find anything. so I need to know if android smartphone support database of 700 MB and how the response time would be to retrieve the data.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
lena
  • 89
  • 1
  • 1
  • 12
  • 1
    Possible duplicate of [What is a maximum size of SQLite database on Android?](https://stackoverflow.com/questions/3482635/what-is-a-maximum-size-of-sqlite-database-on-android) – second Aug 25 '19 at 18:46
  • @second this question is very old and does not reflect the change that has been done on smartphone market – lena Aug 26 '19 at 10:25
  • While the question is quite old, the mentioned limits are still accurate. But the `SQLite` limitations are not directly concerned with hardware limitations. I consider it likely that you hit those first (in a smartphone). Response Time is dependant on the data you store, on the hardware you use and whatever else is currently running on the phone. I doubt you find an explicit answer for that. – second Aug 26 '19 at 12:57
  • I know that but I ask to see if someone work with data of this size on smartphone and know about the performance or if they use partitioning to improve the performance – lena Aug 26 '19 at 14:35

1 Answers1

0

Android contains an SQLite DBMS within itself. You can create and manipulate databases within your android application with SQLite. You can find tutorials for creating and manipulating SQLite android databases: here They represent internal dadabases in the phone like the contacts manager application that we find in each phone.

Otherwise you can put your database in a remote server and you can manage it using RESTful web services : here

Delgado
  • 216
  • 3
  • 16
  • I know how to create a database in android but I am wondering about the capacity of the database in smartphone – lena Aug 25 '19 at 18:35