Re: [sqlite] How to unsubscribe from his group?
Star Trek Epsiode 64, Season 3: The Tholian Web - The Real Unpublished Story Kirk and the ship are trapped in a parallel universe by the weakening of the surrounding fabric of space, and the computer calculates that the next time of spatial interphase will occur in two hours. Meanwhile, the crew of the Enterprise begins suffering from a state of insanity caused by an out of control SQLite email server that is still out of control some 500 years later. 21st century man could not stop the out of control SQLite email server so they decided to beam the messages out into space where it could do no harm. Little did they realize some 500 years later the messages would encounter the star ship Enterprise. Chekov must be put under restraint as he tries unsuccessfully to stop the flow of unwanted e-mails from overpowering the Enterprise's main computer bank. Spock starts to sob uncontrollably when he realizes his mind meld with the renegade SQLite email system is totally futile and has no hope of rationalizing with it. Eventually the entire crew has to be put away in a home for the emailed insane at the nearest star base. Mike At 04:33 PM 8/13/2007, you wrote: Oh Great! Now, you're stuck too? I hate to tell ya, but it seems like we've become victims of a technical support black hole.* You see, there appears to be a "bug" in the unsubscribe function. Their response *may* be to fix the software, or start using different software. But I envision - NOT because of any prior experience with this group - the more typical tech support fix: When enough of us complain often enough, they might tell us to re-install our e-mail client. Or they will remove us from the list by hand, while asking why these dumb users can't follow simple instructions. I mean, if you were bright enough to get on..8-) .( Muttering to self: Dumb cockpit error. ) Oh, and don't come back until you get someone to show you how to send e-mails. Please tip your Waiters, etc. Goodnight. 8-) I hope one of your neighbors has a key, so your pet doesn't suffer.Did you bring any food? I got a soda. *Note this response may contain mild humor, satire, half truths, and material which may be insulting to tech-people. Do not take seriously. mos <[EMAIL PROTECTED] m> To 08/13/2007 04:07 cc PM Subject [sqlite] How to unsubscribe from Please respond to his group? <[EMAIL PROTECTED] ite.org> I've sent half a dozen emails to this address "[EMAIL PROTECTED]" over the past few days and I'm still getting email. Is there a trick to it? Mike >- >To unsubscribe, send email to [EMAIL PROTECTED] >- - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] How to unsubscribe from his group?
I've sent half a dozen emails to this address "[EMAIL PROTECTED]" over the past few days and I'm still getting email. Is there a trick to it? Mike - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] [Visual Basic] How do you work with SQLite?
At 05:25 PM 8/9/2007, you wrote: I use it mainly to manipulate data obtained from an Interbase database. All the data will eventually be dumped to Excel. I use 2 ways to move data from Interbase to SQLite. One, via an ADO recordset after connecting to Interbase with ODBC. This recordset will then be dumped to SQLite via the free VB wrapper from Olaf Schmidt, dhSQLite. Very good and fast wrapper with a rich object model. Two, via a custom Delphi dll that moves data directly from Interbase to SQLite. This is maybe slightly faster than the first method, but not that much difference. So, no ODBC with this method and no ADO recordset. Moving data from SQLite to Excel is all done with dhSQLite. This wrapper can be downloaed from: http://www.thecommon.net/2.html Very much recommended for anybody who works with VB or VBA. RBS RBS, So why can't you manipulate the data in Interbase? It's reasonably fast. Mike - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Creating index takes over an hour
At 01:42 PM 8/9/2007, you wrote: --- mos <[EMAIL PROTECTED]> wrote: > Is there no way to allocate more memory to SQLite index buffers like you > can with MySQL and most other databases? I suspect SQLite is building the > index on disk which will be 100x slower than if it used RAM. The indexing > process has used 400MB of RAM so far and it seems not to want any more even > though there is 800mb free. I could go out and get more RAM, but if SQLite > doesn't use it, what's the point? see the previously mentioned pragma statements: http://www.mail-archive.com/sqlite-users%40sqlite.org/msg26838.html Don't discount the speed increase of OS file caching (pre-caching). It can make a very big difference. Hmmm, I have 2gb RAM on my computer, and the SQLite database (with just this one table) is 10.5 gb. It's like trying to fit an elephant into a phone booth. I can try and squeeze in it, but I don't think it's gonna to fit. And you're telling me, "Well, PUSH HARDER!" Mike > > To build the index on a 15 million row table takes 2 hours. I guy can drink > only so much coffee. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Creating index takes over an hour
At 12:10 PM 8/9/2007, you wrote: > > > cat your.db > /dev/null > > > > > Using Windows XP. :-0 > > Anyone know a simple Windows command line equivalent of the cat > to dev null command above to put a file into OS cache? Well, 'type your.db > nul' will do the same thing, though whether or not it will remain in the cache is another question. Is there no way to allocate more memory to SQLite index buffers like you can with MySQL and most other databases? I suspect SQLite is building the index on disk which will be 100x slower than if it used RAM. The indexing process has used 400MB of RAM so far and it seems not to want any more even though there is 800mb free. I could go out and get more RAM, but if SQLite doesn't use it, what's the point? To build the index on a 15 million row table takes 2 hours. I guy can drink only so much coffee. Mike - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Creating index takes over an hour
At 10:19 AM 8/9/2007, you wrote: If your database file is less than the size of your RAM, then do this before the create index to speed it up: cat your.db > /dev/null See also: PRAGMA cache_size = number-of-pages; and PRAGMA page_size = bytes; -- recommend at least 8192 http://www.sqlite.org/pragma.html Using Windows XP. :-0 Mike --- mos <[EMAIL PROTECTED]> wrote: > I'm building my first index on a large table using the "Create index > ix_Main on Table1(StringField1,StringField2,DateField,TimeField)" and so > far it has been running over an hour on a fast computer with 2gb ram. There > are 15 million rows in the table. The same index can be built in MySQL in a > minute or two. Why does it take so long? Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Creating index takes over an hour
I'm building my first index on a large table using the "Create index ix_Main on Table1(StringField1,StringField2,DateField,TimeField)" and so far it has been running over an hour on a fast computer with 2gb ram. There are 15 million rows in the table. The same index can be built in MySQL in a minute or two. Why does it take so long? Mike - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] New User: Creating/Modifying tables
I created my first Delphi program with DISQLite3 1.40 and I used the Importer component to create the table and I imported a few of the rows from MySQL 5. The problem is the dates in the SQLite table show up as floating point, which is how they are natively stored. 1) How can I determine what the date is with SQLiteSpy? I need the dates formatted as '2006-05-11'. Do I have to write a program every time I 2) How do I create/alter tables with a GUI? I can't find that option in SQLiteSpy or SQLite3 Mgr. TIA Mike - To unsubscribe, send email to [EMAIL PROTECTED] -