Hi Rob,
Regarding: One thing I want to do is to move the conversion of the timestamp from a Julian time to a human-readable time from the query to my application. I may not understand your request fully, but are you asking for more information than is provided in the source files for the conversion routines? (You probably know the full source is online.) BTW, would it be trivially easy to run your query both with and without using sqlite to do the conversion and compare the times? (You may need to run the tests again, in reverse order, to guard against speedups due to caching.) If, with the conversion time reduced to zero, you don't gain much benefit, then working on the outboard conversion would be time wasted. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
