Re: [sqlite] Disk I/O error on AIX

On Aug 4, 2009, at 5:11 AM, Ken wrote: > > Hi, > > I'm getting a Disk I/O error when committing a transaction on an AIX > system. > The file system is JFS. > > > The extended result code is 1290. Which i believe means that the > extended code is a SQLITE_IOERR_DIR_FSYNC error. > > Any ideas

Re: [sqlite] help with inconsistent results and segfault

On Aug 4, 2009, at 4:58 AM, Pavlos Christoforou wrote: > Hello all, > > We are currently evaluating sqlite for using it as the > base engine for a financial reporting module. We have some > fairly complex queries which yield strange results. We have > tried to isolate the problem below. Please

Re: [sqlite] Date Cutoff Statement

#>Rick Ratchford wrote: #>> #>Try #>> #> #>> #>date(max(Date), 'weekday 5') #>> #>> It's likely I'm not using it correctly, because it returns #>nothing. :( #> #>I mean, replace "Date" in your statement with this expression. As in #> #>SELECT date(max(Date), 'weekday 5') FROM MyTable GROUP BY

Re: [sqlite] Date Cutoff Statement

Rick Ratchford wrote: > #>Try > #> > #>date(max(Date), 'weekday 5') > > It's likely I'm not using it correctly, because it returns nothing. :( I mean, replace "Date" in your statement with this expression. As in SELECT date(max(Date), 'weekday 5') FROM MyTable GROUP BY Year, Week; > #>> Is

Re: [sqlite] Date Cutoff Statement

#>> What I ended up with are the number of days per each week (row) and #>> the last date for that week that had data. #> #>Yes, of course. What did you expect? Exactly what I got. :) #> #>> Here are the last few rows. #>> #>> count(*) max(Date) #>> = #>> 5 2009-06-26 #>> 4

Re: [sqlite] Date Cutoff Statement

Rick Ratchford wrote: > What I ended up with are the number of days per each week (row) and > the last > date for that week that had data. Yes, of course. What did you expect? > Here are the last few rows. > > count(*) max(Date) > = > 5 2009-06-26 > 4 2009-07-02 > 5

Re: [sqlite] Date Cutoff Statement

"Igor Tandetnik" schrieb im Newsbeitrag news:h584q5$jo...@ger.gmane.org... > You've truncated the last group short, so a different row from that > "incomplete" group accidentally happened to be chosen. Yep - therefore the recommendation in the VB-newsgroup, to better rely

Re: [sqlite] Merging blobs on disk without taking up memory???

Hello Simon, Monday, August 3, 2009, 8:28:03 PM, you wrote: SD> 2009/8/3 sorka : >> >> Hi. I have a table that stores pieces of an image as a bunch of blobs. I get >> the pieces out of order and store them in a table until I get all of the >> pieces I need. I then want to

Re: [sqlite] Date Cutoff Statement

Hello Igor. What I ended up with are the number of days per each week (row) and the last date for that week that had data. Here are the last few rows. count(*)max(Date) = 5 2009-06-26 4 2009-07-02 5 2009-07-10 5

Re: [sqlite] Date Cutoff Statement

Rick Ratchford wrote: > SELECT Date FROM MyTable GROUP BY Year, Week > > This creates a recordset that groups all my prices into 'weekly' > prices. In other words, each row represents the High, Low, Close > prices for each week, and the date is the FRIDAY DATE of that week. If this happens, then

Re: [sqlite] Date Cutoff Statement

#>> #>> What I want to do is modify this SELECT statement so that the rows #>> returned do not go past a certain date. Let's call it dStopDate. #>> #>> If I have dStopDate = '2009-28-07' #> #>Did you mean '2009-07-28' ? #> Yes. #>> for example, then the last row I want to return is

Re: [sqlite] Disk I/O error on AIX

Ken wrote: > I'm getting a Disk I/O error when committing a transaction on an AIX system. > The file system is JFS. > The extended result code is 1290. Which i believe means that the extended > code is a SQLITE_IOERR_DIR_FSYNC error. > > Any ideas why this is happening or how to track it down?

Re: [sqlite] Date Cutoff Statement

On 4/08/2009 8:52 AM, Rick Ratchford wrote: > > What I want to do is modify this SELECT statement so that the rows returned > do not go past a certain date. Let's call it dStopDate. > > If I have dStopDate = '2009-28-07' Did you mean '2009-07-28' ? > for example, then the last row I want to

Re: [sqlite] Merging blobs on disk without taking up memory???

2009/8/3 sorka : > > Hi. I have a table that stores pieces of an image as a bunch of blobs. I get > the pieces out of order and store them in a table until I get all of the > pieces I need. I then want to assemble them in order and store the resulting > complete image in in

Re: [sqlite] Date Comparisons SQL

"Rich Shepard" schrieb im Newsbeitrag news:alpine.lnx.2.00.0908031516300.3...@salmo.appl-ecosys.com... > > It was set as String actually. > > Rick, > >That's the storage class; well, TEXT is the storage class. Yep. > > I believe this is a WRAPPER thing though.

[sqlite] Date Cutoff Statement

I'm stuck on a problem that is halting my project. I hope someone can help on this one as I think it's a SQL related question. MyTable contains the Date, Year, Week (and other columns). Week is a week number. MyTable holds my stock prices for each trading day. I've omited the price data

Re: [sqlite] Disk I/O error on AIX

On 3 Aug 2009, at 11:11pm, Ken wrote: > I'm getting a Disk I/O error when committing a transaction on an AIX > system. > The file system is JFS. Check all the obvious things: Is there free space on drive ? If you replace that transaction by a very simple INSERT, or by a DELETE, do you get

Re: [sqlite] Date Comparisons SQL

Olaf tells me that it's stored as Text-String. Either as '-mm-dd' or '-mm-dd hh:mm:ss', depending on how I decide to store my VB type dates. Anyway, the original problem was solved. I simply neglected to address the need for 'quotes' around my date variable. Thanks Rich. :-) Rick

[sqlite] Merging blobs on disk without taking up memory???

Hi. I have a table that stores pieces of an image as a bunch of blobs. I get the pieces out of order and store them in a table until I get all of the pieces I need. I then want to assemble them in order and store the resulting complete image in in another table entirely. Is there a smart way to

Re: [sqlite] Date Comparisons SQL

On Mon, 3 Aug 2009, Rick Ratchford wrote: > It was set as String actually. Rick, That's the storage class; well, TEXT is the storage class. > I believe this is a WRAPPER thing though. I'm programming in VB6 and using > Olaf's VB wrapper. Oh. I know nothing about Microsoft languages (or

[sqlite] Disk I/O error on AIX

Hi, I'm getting a Disk I/O error when committing a transaction on an AIX system. The file system is JFS. The extended result code is 1290. Which i believe means that the extended code is a SQLITE_IOERR_DIR_FSYNC error. Any ideas why this is happening or how to track it down? Thanks, Ken

Re: [sqlite] Date Comparisons SQL

It was set as String actually. I've since changed it to ShortDate today. I believe this is a WRAPPER thing though. I'm programming in VB6 and using Olaf's VB wrapper. :) Rick #>-Original Message- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On

[sqlite] help with inconsistent results and segfault

Hello all, We are currently evaluating sqlite for using it as the base engine for a financial reporting module. We have some fairly complex queries which yield strange results. We have tried to isolate the problem below. Please see select queries at the end and associated comments which

Re: [sqlite] Date Comparisons SQL

On Mon, 3 Aug 2009, Rick Ratchford wrote: > The native Date in a table without any additional expressions is > '-mm-dd 00:00:00'. Rick, That's a timestamp format. Did you specify the column as date or timestamp? Rich -- Richard B. Shepard, Ph.D. | Integrity

Re: [sqlite] Week

Thank u very much!!! :) the end of the week can be select (case strftime('%w', T) when '0' then T else date(T, 'weekday 0') end) from (select date('now') as T); --or Igor Tandetnik wrote: > > helemacd wrote: >> anybody know how to return the start of the week and end of the >> week??? >

Re: [sqlite] Date Comparisons SQL

And that, my friend, was the missing link! Thank you! Rick #>-Original Message- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of David Bicking #>Sent: Monday, August 03, 2009 1:57 PM #>To: General Discussion of SQLite Database

Re: [sqlite] Date Comparisons SQL

I think your problem is that you need to put the value in sDateTemp in quotes. "WHERE Date < '" & sDateTemp & "'" or "WHERE Format$(Date, "-mm-dd") < '"& sDateTemp & "'" Without the quote, I think sqlite is subtracting the day from the month from the year, and comparing that number with

Re: [sqlite] Week

helemacd wrote: > anybody know how to return the start of the week and end of the > week??? select (case strftime('%w', T) when '0' then T else date(T, 'weekday 0', '-7 days') end) from (select date('now') as T); -- or select date(T, '-' || strftime('%w', T) || ' days') from (select

Re: [sqlite] Date Comparisons SQL

Okay, I think I understand what you are saying. The native Date in a table without any additional expressions is '-mm-dd 00:00:00'. Those "00:00:00" must be my problem. Rick #>-Original Message- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org]

Re: [sqlite] Date Comparisons SQL

> I've attached a view of the results from the working SQL statement that does > not perform the WHERE. Attachments do not come through to this list. > Also, as stated in my previous post, I have sDateTemp formatted in the same > format as that which is in the table. Could you elaborate: your

Re: [sqlite] Date Comparisons SQL

That's the clincer. The resulting DATE column is actually the format of the equation as well. I've attached a view of the results from the working SQL statement that does not perform the WHERE. "WHERE Format$(Date, '-mm-dd') < sDateTemp" does not work. Also, as stated in my previous post,

[sqlite] Week

Hi, anybody know how to return the start of the week and end of the week??? Thanks!! -- View this message in context: http://www.nabble.com/Week-tp24795944p24795944.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users

Re: [sqlite] Date Comparisons SQL

Rick Ratchford wrote: > The Date is being stored as -mm-dd. Note the "Format$(Date, > '-mm-dd') as Date" that assures this. The "Date" that appears in the WHERE clause is the value of the Date column in the table, not the value of the expression with the "Date" alias. You can't actually

Re: [sqlite] Date Comparisons SQL

That was a quick response! The Date is being stored as -mm-dd. Note the "Format$(Date, '-mm-dd') as Date" that assures this. And I have it in this format for sDateTemp so that they would compare the same. But it does not work. So what am I doing wrong? Thanks. Rick

Re: [sqlite] ANN: SQLite 3.6.16.C#

I need to apologize once again. Slow deletes explained as bug in SQLite tests and flags of Perst compilation. Now they both head to head on basic ops with 2x on Perst selects (can be due to the ADO reader instantiations) http://www.nabble.com/file/p24795746/TestIndex.cs TestIndex.cs SQLITE

Re: [sqlite] ANN: SQLite 3.6.16.C#

I need to apologize once again. Slow deletes explained as bug in SQLite tests and flags of Perst compilation. Now they both head to head on basic ops with 2x on Perst selects (can be due to the ADO reader instantiations) http://www.nabble.com/file/p24795731/TestIndex.cs TestIndex.cs SQLITE

Re: [sqlite] Date Comparisons SQL

> How do you properly do a Date comparison in SELECT so that the only rows > returned are those that do not exceed the date found in my sDateTemp > variable? As a simple string comparison. You made it perfectly right except that your Date field should be stored in a format '-mm-dd' in

[sqlite] Date Comparisons SQL

This works: SQLString = "SELECT Format$(Date, '-mm-dd') as Date, Year, Month, Day, Open, High, Low, Close, DayNum, 0 as IsSwingTop1, 0 as IsSwingBtm1, 0 as IsSwingTop2, 0 as IsSwingBtm2, Null as Delta1, Null as Delta2, 0 as Offset1, 0 as Offset2 FROM [" & sTable & "] GROUP BY Year, Month,

[sqlite] Richard Schmidt is out of the office.

I will be out of the office starting 08/03/2009 and will not return until 08/04/2009. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Use of in memory db

Sharma, Gaurav wrote: > Please clear my one more doubt. Is it true that either using the > SQLITE_THREADSAFE=1 as compile time flag or using > SQLITE_OPEN_FULLMUTEX with sqlite3_open_v2 are same thing. Both can > be used interchangeably. Correct me if I am wrong. Once you compile with

Re: [sqlite] ANN: SQLite 3.6.16.C#

Sorry, test bug in SQLite select test. http://www.nabble.com/file/p24789308/TestIndex.cs TestIndex.cs index searches: 20: SQLITE 8.1635400 PERST 3.3406065 200: SQLITE 1:10.6331745 PERST 54.9915975 - Best Regards. Max Kosenko. -- View this message in context:

Re: [sqlite] Use of in memory db

Hi All, Please clear my one more doubt. Is it true that either using the SQLITE_THREADSAFE=1 as compile time flag or using SQLITE_OPEN_FULLMUTEX with sqlite3_open_v2 are same thing. Both can be used interchangeably. Correct me if I am wrong. Secondly, Is it possible by any mean that for

Re: [sqlite] ANN: SQLite 3.6.16.C#

Dan Kennedy-4 wrote: > Earlier I just quoted the conclusions of the McObject report. Maybe I > misunderstood. But now that I have read the benchmark code, I'm curious. > Why is the SQL not being recompiled for each query? Is there some kind of > compiled query cache hiding behind the

Re: [sqlite] ANN: SQLite 3.6.16.C#

Dan Kennedy-4 wrote: > Are you by any chance the author of the report I'm reading? I'm not an author of test or McObject staff/representative at all. But I can give a link to this forum to author (still insisting that this is offtopic here) to answer himself. - Best Regards. Max Kosenko. --

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Aug 3, 2009, at 2:06 PM, Kosenko Max wrote: > > > Dan Kennedy-4 wrote: >> McObject CEO Steve Graves points out that because of limits of the >> API >> they were using, SQLite performs each INSERT and DELETE in the test >> in a >> separate transaction. So the reported times for these tests

Re: [sqlite] ANN: SQLite 3.6.16.C#

Dan Kennedy-4 wrote: > McObject CEO Steve Graves points out that because of limits of the API > they were using, SQLite performs each INSERT and DELETE in the test in a > separate transaction. So the reported times for these tests may be more of > a measure of the speed of the media than SQLite

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Aug 2, 2009, at 6:25 PM, Kosenko Max wrote: > > 9/30054 means 99.97% tests are working. > That's a great achievement anyway. > Performance problems can be profiled and optimized simpler than with > native > version. > > That isn't a nature of managed code to be slow. i.e. Perst DB which is