CODEWITHSUNDEEP
c++sqliteqtconfiguration
AimingHigh
AimingHigh

Reputation: 141

Sqlite max columns number configuration from QT

I want to store rows that have 65536 columns in a Sqlite database, and I am doing that using C++ and QT.

My question is: Since the default maximum number of columns seems to be 2000 no more, how to configure this parameter from C++ and Qt?

Thank you.

Upvotes: 1

Views: 530

Answers (1)

Tim Meyer
Tim Meyer

Reputation: 12600

The SQLLite homepage has some explanation on this:

2.Maximum Number Of Columns

The SQLITE_MAX_COLUMN compile-time parameter is used to set an upper bound (...)

and

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.

Like that, even if you increased it, you could only achieve half of what you want. Apart from that I can only refer to Styne666's comment on your post.

Upvotes: 2

Related Questions