# Local db maximum rows

**URL:** <https://community.thunkable.com/t/local-db-maximum-rows/591012>\
**Category:** Questions about Thunkable X\
**Created:** [June 3, 2020, 6:38pm UTC](https://community.thunkable.com/t/local-db-maximum-rows/591012 "2020-06-03T18:38:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mahmoudgamal\_007pz9b](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@mahmoudgamal\_007pz9b](https://community.thunkable.com/u/mahmoudgamal_007pz9b)\
**Post date:** [June 3, 2020, 6:38pm UTC](https://community.thunkable.com/t/local-db-maximum-rows/591012/1 "2020-06-03T18:38:31Z")

</div>

Hello,  
Can someone answer me please regarding what is the maximum number of rows allowed in the local db and the maximum inputs?

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [June 4, 2020, 7:57am UTC](https://community.thunkable.com/t/local-db-maximum-rows/591012/2 "2020-06-04T07:57:33Z")

</div>

Hello,

I think it’s hard to get an answer to your question. My practice shows that if you copy 700-800 kilobytes of text to a text block, then attempts to work with such a block can cause problems.Will the local table work better? This can only be checked in practice, but I would not cram more than 1 megabyte and 10-20 thousand rows of data into it

---

<div class="post-metadata">

**Author:** ![mahmoudgamal\_007pz9b](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@mahmoudgamal\_007pz9b](https://community.thunkable.com/u/mahmoudgamal_007pz9b)\
**Post date:** [June 11, 2020, 9:24pm UTC](https://community.thunkable.com/t/local-db-maximum-rows/591012/3 "2020-06-11T21:24:46Z")

</div>

Hi @actech,  
Sorry for the multiple questions, but I’m stuck in this issue, The data viewer list or grid while using the local table is storing data on the device so if the user is having two different accounts personalized differently for viewing different data he will see both data of the two accounts when he opens any account of them on the same device. So I’m asking how to prevent this? Thanks for your help.

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [June 12, 2020, 9:50am UTC](https://community.thunkable.com/t/local-db-maximum-rows/591012/4 "2020-06-12T09:50:42Z")

</div>

To separate accounts, you need to use a database that allows you to do this, for example, Firebase

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 11:27am UTC](https://community.thunkable.com/t/local-db-maximum-rows/591012/5 "2024-11-08T11:27:07Z")

</div>