Re: loading and select

[Anantha Varatharajan]

thanks rick. actually I am using myisam table but for test I created on innodb. I have removed those indexes you suggested and things are much better. I repaired the table and moved those to 5.5 version. I am at the moment loading the data to the table and query from it. I am using using java utility which runs to load the data to the table. The table is 1gig is size and going to be 2-5 gig max over the time. There will be deletes happening on the table frequently as well. The requirement is the table needs to available all the time with good query performance


* Load into a new table, RENAME to swap tables. This assumes you are replacing all rows, in which case, it is an excellent and fast workaround.
-- "no, we are not replacing all the data. We replace only few rows"

* Load into a new table, REPLACE into the existing table 100 rows at a time. (Use some index to walk through the new table; do not have the 4 indexes that you otherwise need.)
-- "Could you explain this a bit please? I need to load the data to a table and again load to the new table with replace command. isn't?


could you suggest me any other options?

Also the os seems to be caching more. How to disable the os caching?
thanks