On 10 Apr 2012, at 7:09am, Rick Guizawa <[email protected]> wrote:
> Hi All, I would very much appreciate if someone could help me speed up my > database table insertion process as what I have in the followings took a > long time to complete even when using sqlite3 shell command. > > Thank you in advance for your help. > > Cheers, > Rick > > [LastBuyDate] DATE NOT NULL, SQLite does not have a 'DATE' type. You can store dates as text or numbers, in various forms. Whatever form you choose to store your dates in should tell you what the affinity that column should have. A great deal of code in your INSERT command is involved in trying to pick out parts of dates doing things like CAST(strftime(%J',..)) rethink your data storage so that this is no longer necessary. Since you are repeatedly trying to change a date into Julian number form, store the date as Julian number form instead of the form you're currently using. Then you don't have to have every INSERT do such a lot of conversion. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
