Hi, I'm using sqlite as a temporary store for flattened report database (generally just one table). This data is pulled out in chunks using OFFSET and LIMIT. This particular setup is quite simple... just insert all of the data, and then pull it out chunk by chunk afterwards.
What I'm wondering about is whether I should put an integer primary key on the data table to ensure that the ordering is correct, or if "SELECT * FROM <table> LIMIT <x> OFFSET <y>" will reliably return data in the same order in which is was inserted. It seems to, but I'd rather not take that for granted... Thanks! Kevin -- Kevin Dangoor TurboGears / Zesty News email: [EMAIL PROTECTED] company: http://www.BlazingThings.com blog: http://www.BlueSkyOnMars.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
