If MonetDB could use table partition ?
Stefan.Manegold at cwi.nl
Mon Jul 22 09:23:32 CEST 2013
After how many files does the loading get how slow?
I.e., could you share the loading time of each file, starting from the first until it becomes "very slow"
----- Original Message -----
> Hi Meng,
> are you loading all 1000 FITS files into the same table, or each in its own
> What is the schema of your table, i.e., what are the types of the 21 columns?
> Which operating system are you running on, and how much memory (RAM) does
> your machine have?
> ----- Original Message -----
> > I am using "COPY BINARY INTO ...FROM ..." to insert 1000 FITS files into a
> > table and the table has 21 columns, every FITS file has 200000 records.
> > After some FITS files, the loading becoming very slowly,
> > so If MonetDB could use table partition to accelerating the copy?
> > or if Data Vaults could be loading more quickly?
> > Thanks!
> > Meng
> > _______________________________________________
> > users-list mailing list
> > users-list at monetdb.org
> > http://mail.monetdb.org/mailman/listinfo/users-list
> | Stefan.Manegold at CWI.nl | DB Architectures (DA) |
> | www.CWI.nl/~manegold/ | Science Park 123 (L321) |
> | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
| Stefan.Manegold at CWI.nl | DB Architectures (DA) |
| www.CWI.nl/~manegold/ | Science Park 123 (L321) |
| +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
More information about the users-list