Re: [Virtuoso-users] Insert data fast

2009-05-22 Thread Tim Haynes
Yrjänä Rankka wrote: Sören Auer wrote: Ivan Mikhailov wrote: Unfortunately, we can offer plain INSERTs only, but they're not bad, esp. when parametrized. You mean wen run as prepared statements? Yes. You prepare statement, then exec it repeatedly with parameters - this is the faste

Re: [Virtuoso-users] Insert data fast

2009-05-19 Thread Yrjänä Rankka
Sören Auer wrote: Ivan Mikhailov wrote: Unfortunately, we can offer plain INSERTs only, but they're not bad, esp. when parametrized. You mean wen run as prepared statements? Yes. You prepare statement, then exec it repeatedly with parameters - this is the fastest way of inserting

Re: [Virtuoso-users] Insert data fast

2009-05-19 Thread Sören Auer
Ivan Mikhailov wrote: Unfortunately, we can offer plain INSERTs only, but they're not bad, esp. when parametrized. You mean wen run as prepared statements? Your request for fast CSV loading is the first one for this feature, we can schedule that, but not for this month, I'm afraid. I guess

Re: [Virtuoso-users] Insert data fast

2009-05-19 Thread Sören Auer
Kingsley Idehen wrote: Are you loading SQL. RDF, or RDF via SQL channel into Virtuoso? We need to know which of these you mean before providing a response about optimal paths. Its just plain SQL - else I wouldn't have compared Virtuoso to MySQL ;-) --Sören

Re: [Virtuoso-users] Insert data fast

2009-05-19 Thread Kingsley Idehen
Sören Auer wrote: Hi, I'm currently making some experiments with loading really large data into Virtuoso and I'm wondering whether there are ways to speed up loading of data into empty tables. mySQL e.g. allows to disable keys and to load data from CSV files, which is by factor 5 faster than

Re: [Virtuoso-users] Insert data fast

2009-05-19 Thread Ivan Mikhailov
Hello Sören, Unfortunately, we can offer plain INSERTs only, but they're not bad, esp. when parametrized. Your request for fast CSV loading is the first one for this feature, we can schedule that, but not for this month, I'm afraid. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.

[Virtuoso-users] Insert data fast

2009-05-19 Thread Sören Auer
Hi, I'm currently making some experiments with loading really large data into Virtuoso and I'm wondering whether there are ways to speed up loading of data into empty tables. mySQL e.g. allows to disable keys and to load data from CSV files, which is by factor 5 faster than traditional insert