| Subject | Re: [firebird-support] Re: commit after insert is very slow |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2010-03-03T17:15:51Z |
> the table have more than 10 000 000 records (actually many more)Curiosity: what kind of area has more than 10 000 000 houses? What
> now we need to retrieve any kind of subset in any of the previous available order by, and this in lower than 100 ms !
will happen at 101st millisecond? They will burn?
IMHO - you should think about partitioning.
--
SY, SD.