# SQLite unique column

**URL:** <https://forum.ionicframework.com/t/sqlite-unique-column/122010>\
**Category:** ionic-v3\
**Created:** [February 20, 2018, 6:59am UTC](https://forum.ionicframework.com/t/sqlite-unique-column/122010 "2018-02-20T06:59:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eyasso](https://avatars.discourse-cdn.com/v4/letter/e/e68b1a/32.png) [@Eyasso](https://forum.ionicframework.com/u/Eyasso)\
**Post date:** [February 20, 2018, 6:59am UTC](https://forum.ionicframework.com/t/sqlite-unique-column/122010/1 "2018-02-20T06:59:33Z")

</div>

Hi,

I am using the SQLite inside mobile. assuming my table has 5 columns and it contains ~10,000 records, can I use unique for column? Is it too much for a mobile to use this functionality? The column is on text column on barcode which can be up to 15 chars. Would it take too long for mobile to scan on every insert?

Thanks,

---

<div class="post-metadata">

**Author:** ![mhartington](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/mhartington/32/137757_2.png) [@mhartington](https://forum.ionicframework.com/u/mhartington)\
**Post date:** [July 19, 2021, 9:50pm UTC](https://forum.ionicframework.com/t/sqlite-unique-column/122010/2 "2021-07-19T21:50:02Z")

</div>

Closed on July 19, 2021, 9:50pm UTC