Reputation: 2018
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
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
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
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