I'd probably use a commit size in your case of 50k or 100k. Try to use the neo4j-shell and not the web-interface.
Connect to neo4j using bin/neo4j-shell Then run your commands ending with a semicolon. Just curious: Your data is imported as one node per row? That's not really a graph structure. On Wed, Jun 4, 2014 at 6:56 PM, Paul Damian <[email protected]> wrote: > Hi there, > > I'm experimenting with Neo4j while benchmarking a bunch of NoSQL databases > for my graduation paper. > I'm using the web interface to populate the database. I've been able to > load the smaller tables from my SQL database and LOAD CSV works fine. > By small, I mean a few columns (4-5) and some rows (1 million). However, > when I try to upload a larger table (15 columns, 12 million rows), it > creates the nodes but it doesn't set any properties. > I've tried to reduce the number of records (to 100) and also the number of > columns( just the Id property ), but no luck so far. > > The cypher command used is this one > USING PERIODIC COMMIT 100 > LOAD CSV WITH HEADERS FROM "file:/Users/pauld/Documents/Client.csv" AS c > CREATE (:Client { Id: toInt(c.Id), FirstName: c.FirstName, LastName: > c.Lastname, Address: c.Address, ZipCode: toInt(c.ZipCode), Email: c.Email, > Phone: c.Phone, Fax: c.Fax, BusinessName: c.BusinessName, URL: c.URL, > Latitude: toFloat(c.Latitude), Longitude: toFloat(c.Longitude), AgencyId: > toInt(c.AgencyId), RowStatus: toInt(c.RowStatus)}) > > Any help and indication is welcomed, > Paul > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
