CODEWITHSUNDEEP
androiddatabasesqlite
Shahzad Imam
Shahzad Imam

Reputation: 2018

Maximum Number of Columns in Sqlite in Android

Actually I am having 11 columns in my Database(Sqlite).Now I am increasing the number of columns to 15.Will it affect my application?If Yes, then what will be the feasible solution?

Upvotes: 0

Views: 10017

Answers (3)

Akram
Akram

Reputation: 7527

i think it wont.

The default setting for SQLITE_MAX_COLUMN is 2000. You can change it at compile time to values as large as 32767. On the other hand, many experienced database designers will argue that a well-normalized database will never need more than 100 columns in a table.

so in your case 15 would not be an issue i think.

Upvotes: 5

Sai Mukesh
Sai Mukesh

Reputation: 411

It wont effect the application .....

Actually If the table grows vertically there will be performance problems...

But there wont be any effect if it grows horizontally....

Any how i prefer you to normalize the tables if there is any possibility...

Upvotes: 0

Saifuddin Sarker
Saifuddin Sarker

Reputation: 863

No it should not effect on application as long as you have enough memory Check this link here: http://www.sqlite.org/limits.html

Upvotes: 2

Related Questions