Re: [sqlite] Variable-length records

2013-04-19 Thread Jay A. Kreibich
On Fri, Apr 19, 2013 at 08:19:57AM +0200, Hick Gunter scratched on the wall: > IIRC temporary tables are limited to the connection that creates them. Yes. So are in-memory databases. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that

Re: [sqlite] Variable-length records

2013-04-19 Thread Bk
Thank You -- View this message in context: http://sqlite.1065341.n5.nabble.com/Variable-length-records-tp68277p68300.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:

Re: [sqlite] Variable-length records

2013-04-18 Thread Hick Gunter
IIRC temporary tables are limited to the connection that creates them. -Ursprüngliche Nachricht- Von: Simon Slavin [mailto:slav...@bigfraud.org] Gesendet: Donnerstag, 18. April 2013 19:30 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Variable-length records On 18 Apr

Re: [sqlite] Variable-length records

2013-04-18 Thread Simon Slavin
On 18 Apr 2013, at 10:38am, Bk wrote: > can some one tell me which of the tcl test script tests below two points of > SQLite ? > > 1) Variable-length records If you're using the term 'variable length' because you're used to a different SQL engine, then there's a paradigm shift: almost all SQL

[sqlite] Variable-length records

2013-04-18 Thread Bk
can some one tell me which of the tcl test script tests below two points of SQLite ? 1) Variable-length records 2) Internal or temporary databases: load the data into an in-memory SQLite database and use queries with joins and ORDER BY clauses to extract the data in the form and order needed T

[sqlite] Variable-length records

2005-05-03 Thread Maurício M. Maia
Hi, The SQLite documentantion 'Distinctive Features' says: "If you store a single character in a VARCHAR(100) column, then only a single byte of disk space is consumed. (Actually two bytes - there is some overhead at the beginning of each column to record its datatype and length.)" I would like