py2neo - Neo4j - poor performance -

-

i receive daily full csv file customers. need insert/update neo4j database. using query:

i create indexes on hash field.

merge (xfewyx:customer_bseller {hash:'xyz@hotmail.com'} ) on create set xfewyx.hash = 'xyz@hotmail.com',xfewyx.name = 'xyz ',xfewyx.birthdate = '1975-05-20t00:00:00',xfewyx.id = '1770852',xfewyx.nick = 'clarissa',xfewyx.documentnumber = 'xyz',xfewyx.email = 'clarissajuridica@hotmail.com'  xfewyx merge (whhekx:email {hash:'clarissajuridica@hotmail.com'} ) on create set whhekx.hash = 'clarissajuridica@hotmail.com',whhekx.email = 'clarissajuridica@hotmail.com'  xfewyx,whhekx merge (jjkont:document {hash:'06845078700'} ) on create set jjkont.document = 'xyz',jjkont.hash = '06845078700'  xfewyx,whhekx,jjkont merge (merucb:phone {hash:'nonenone'} ) on create set merucb.areacode = 'none',merucb.hash = 'nonenone',merucb.number = 'none'  xfewyx,whhekx,jjkont,merucb merge (boorbt:phone {hash:'xyz'} ) on create set boorbt.areacode = '21',boorbt.hash = 'xyz',boorbt.number = 'xyz'  xfewyx,whhekx,jjkont,merucb,boorbt merge (xblznf:phone {hash:'xyz'} ) on create set xblznf.areacode = '21',xblznf.hash = 'xyz',xblznf.number = 'xyz'  xfewyx,whhekx,jjkont,merucb,boorbt,xblznf merge (xfewyx)-[:registered_with {optin:'false'}]->(whhekx) merge (xfewyx)-[:document]->(jjkont) merge (xfewyx)-[:commercial_phone]->(merucb) merge (xfewyx)-[:phone]->(xblznf) merge (xfewyx)-[:cell_phone]->(boorbt)

does have approach how execute query?

i try using profile command. might put limit on load csv (i assume you're using load csv) testing.

i check out article:

http://www.markhneedham.com/blog/2014/10/23/neo4j-cypher-avoiding-the-eager/

some of has been fixed in recent versions of neo4j, have awful lot of merges there, stand split of , process csv file more once.


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more