On 11/7/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
I am trying for loading only that table one into memory. Beacuse in my DB I have two or more three table which are quite large and I don't want to waste memory. Is it possible that way.
I believe you can attach the database ":memory:" to your existing database and use simple sql to copy it from one database to another (this would "load it into memory"). I'm not sure that is what you want though. You are aware the operating system will probably cache the database in memory automatically (if it will fit) anyway? Doing it manually may not help any ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------