Hello Chetan,
Wednesday, January 23, 2002, 6:09:39 PM, you wrote:
CL> you might be knowing that the MySQL also supports another table types as
CL> InnoDB,MyISAM(default),heap etc..
CL> Actually what I wanted to do is that the data should remain in the
CL> memory(memory-resident)while querying and this should also be replicated
CL> in the secondary memory so that if server goes down, my data is saved in
CL> the secondary memory.
CL> 1. I have tried without HEAP table , but as it creates the table of type
CL> MyISAM(by default), and in this case the data and indexes are stored in
CL> the file which make the server performance slow.
CL> 2. then I have tried with the HEAP table but in this case the tables
CL> created remains in the heap
CL> (though it give better performance) but If server goes down, my table
CL> data get lost.
CL> So, what should I do so that I can make my database memory-resident as
CL> well as should also able to do it's secondary storage. I am reading
CL> about the InnoDB table option. will it be feasible.??
Yes. That would be probably interesting for you to take a look at MySQL 4.0.x server as
its query caching may help your situation.
CL> Chetan
--
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
<___/ www.mysql.com
--
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
<___/ www.mysql.com
