Wednesday, January 23, 2002, 7:56:33 AM, you wrote:
CL> O.K., when I am creating the table as a heap type these are created as a
CL> temporary tables as in
CL> when I shutdown the server all the table(heap-table) content no where
CL> exits. so suppose I create all my table as a type heap, then shutting
CL> down of server means I will loose all my data, isn't it?
CL> so, what's the method by which table contents remain in the secondary
CL> storage, while I am creating the table as a heap type.
Simply: don't use TYPE=HEAP. ;-)
Either your table is temporal and stored only in memory or it is
not temporal and stored on a disk.
This way, query caching in 4.0.x server will probably help you to run queries faster. For
you, this will look similar to a table that is completely in RAM.
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net