[sqlite] Question about database design

Hello! I have over 100 columns in a table. Most of the columns will stay empty. Just an example: customer_lastname customer_firstname customer_street customer_PhonePrivate (will almost always stay empty) customer_PhoneCompany customer_PhoneMobile customer_PhoneWAP (will almost always stay empty)

Re: [sqlite] Mozilla's method

Thanks Olaf. On Sat, Jan 2, 2010 at 12:49 AM, Olaf Schmidt s...@online.de wrote: Artur Reilin sql...@yuedream.de schrieb im Newsbeitrag news:op.u5vno6hp1pq...@rear... If you are using something like an log system it would be better in this way, but in apps like an shop what wouldn't be

[sqlite] Storing large numeric values

I am trying to save values like 19.000.000.000 to my database but I haven't found the appropriate column type yet. Can anybody help please. I am using the dhRichClient command object, but even Int64 isn't large enough. ___ sqlite-users mailing list

Re: [sqlite] Mozilla's method

? Does a select command automatically trigger a .CommitTrans? Wishing you a happy new year! On Fri, Jan 1, 2010 at 9:11 AM, Olaf Schmidt s...@online.de wrote: Bert Nelsen bert.nel...@googlemail.com schrieb im Newsbeitrag news:a5ffd530912311004p26a7cc5k1f1bf6f671bef...@mail.gmail.com... Your

Re: [sqlite] Mozilla's method

So SQLite looks at both the database on the disk and in memory? Wouldn't that be difficult??? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Mozilla's method

Hello, I would like to make writes to my SQLite db faster. I was thinking about the Async method, but I think I remember reading somewhere that it may cause database corruption. Now I read something on the Mozilla pages, and I don't understand what exactely they are doing. Do they bundle

Re: [sqlite] Mozilla's method

statement[s] in a transaction, you want to use this: https://developer.mozilla.org/En/Storage#Asynchronously Cheers, Shawn Wilsher Mozilla Developer On Thu, Dec 31, 2009 at 8:53 AM, Bert Nelsen bert.nel...@googlemail.com wrote: Hello, I would like to make writes to my SQLite db faster

Re: [sqlite] Mozilla's method

: Bert Nelsen bert.nel...@googlemail.com schrieb im Newsbeitrag news:a5ffd530912310853t7024d908tefbf1ef40df47...@mail.gmail.com... I would like to make writes to my SQLite db faster. In what regard (under which circumstances) is it slow currently? What's your typical recordcount per

[sqlite] Index is not being used

Hello! I have the problem that one index is not taken into account when I execute a query: I have 1 table with 2 columns. Each column has an index, but EXPLAIN QUERY PLAN tells me that the second index is not being used. -- First column: name: mycolumn1 type: text collation: nocase unique: