| Subject | RE: Insert into Large Table is slowly! |
|---|---|
| Author | |
| Post date | 2013-09-07T15:07:52Z |
The page isze is 16KB.
I'm not run gstat. I will try do it.
jimmy
--- In firebird-support@yahoogroups.com, <Sean@...> wrote:> I have 5-10 billions rows in table, and insert 50,000 rows every hour.What is your database page size?
> If so, I can not inactive index or spend a lot of time to reactive it.
> thanks.
Have you run gstat to look at the index stats for the table?
Sean