speed of importing

[jda]

>So problem NOT in the cache overhead.
>
>
>Hmm. This db must be able created in 1 second ideally.
>
>With indexing longer of course. You have big texts.
>Each record means adding about 1000 points into indexes.
>
>So it looks like you have db in 400,000 records.
>
>But still...
>

I turned OFF indexing and imported these 1000 records -> ~ 120 seconds

With indexing ON -> ~ 112 seconds

(times are approximate, so I'd say there was no difference).

Jon