[sqlite] Single Support

If I get it correctly, currently SQLite only supports REALS only as Double, requiring 8 byte per number, which is for many applications quite expensive. What are the chances to get Single support in a future release? What is the appropriate way to propose such a feature? I understand that there

Re: [sqlite] Limitation on Column count

Hi Pavel, yes - you are quite right, I wasn't precise here! Sorry about that! What I meant was a join on unit_id, which obviously will have an index if that's needed. Thanks for your help! Kind regards Stefan Btw., in the same context, I noticed

Re: [sqlite] Limitation on Column count

Hi all, based on Pavels input, I did some quick trials and thought I let you know the results. I'm running on an old pentiu...@3.2ghz with 3G memory and Win-7. So, don't expect super-fast times! 1. I have one DB with 5411 units and 1517 measurements with columns unit_id, m_1, .. m_1517

Re: [sqlite] Limitation on Column count

ork fast enough and it will > be better than creating such huge table. > > > Pavel > > On Tue, Jan 12, 2010 at 1:09 PM, Stefan_E <se_m...@hotmail.com> wrote: >> >> Hi Adam, >> >> thanks for your suggestion. Unfortunately, it doesn't help in m

Re: [sqlite] Limitation on Column count

regate, such as lots of mutually exclusive binary flag fields. > > regards, > Adam > > On Mon, Jan 11, 2010 at 3:46 PM, Stefan_E <se_m...@hotmail.com> wrote: > >> >> Hello all, >> >> I'm considering using SQLite for a new application. The schema will &g

[sqlite] Limitation on Column count

Hello all, I'm considering using SQLite for a new application. The schema will contain a bunch of small tables with few columns (~10) plus one large table with many columns and 1000...1 rows. 'Many columns' typically fits into the default 2000 column limit, but can exceed it at times (that