During the initial import of data to the {{post id=”jabbermetanetnz-has-moved” text=”new jabber.meta.net.nz server”}}, I noticed that the roster information failed to be migrated if I was using an ODBC backend – it would just fail entirely. I didn’t think too much of it until I tried to restart ejabberd, and noticed that it spent around 5 minutes initializing it’s mnesia database. There’s around 220,000 roster entries in the database, and that’s after I culled around 9000 accounts that hadn’t been used in more than 180 days.<\/p>\n
So, I decided to have another look at moving the content to an SQL backend. I noticed that one of the many commands available from the ejabberdctl cmdline tool is an export2odbc command. It didn’t seem to work at first, but it turns out I had the parameters slightly wrong – this post<\/a> set me straight. So, I started importing all the tables, including the roster table, into my database<\/p>\n I then noticed that it appears to be doing one, sometimes two deletes, for every insert. I have an empty database, so there’s no real need for this, and there’s 220,000 entries. During the 30 minutes or so I spent playing round with other ways to do this import I only got to around 115,000 entries added! The export command had output the content on the smallest number of lines possible, so after free ringtones maker<\/a>free funny voice ringtones<\/a>download free cingular ringtones<\/a>free mp3 nextel ringtones,nextel mp3 ringtones,mp3 nextel ringtones<\/a>ringtones gratis,1100 gratis nokia ringtones,c115 gratis motorola ringtones<\/a>download free new ringtones<\/a>carrier cellular free ringtones us<\/a>free nokia ringtones tracfone<\/a>free nickelback ringtones,nickelback ringtones,nickelback ringtones rockstar<\/a>download ringtones for sprint phone,sprint download ringtones<\/a>free lg ringtones verizon vx6000<\/a>box music ringtones sony,sony music box ringtones<\/a>cell free phone ringtones samsung<\/a>info motorola personal remember ringtones t731,info motorola personal remember ringtones,info motorola personal remember ringtones v66<\/a>totally free cell phone ringtones<\/a>computer download free ringtones<\/a>1 hour loan payday,payday loan in 1 hour,1 hour payday loan<\/a>savings account payday loan<\/a>no fax payday advance loan<\/a>quick low interest payday loan,loan payday quick,quick pay payday loan<\/a>no bank statement payday loan<\/a>bank loan no payday statement<\/a>loan payday until,loan payday say until wordpress,loan until payday<\/a>fast payday loan<\/a>quick cash payday loan<\/a>line loan payday,payday loan on line<\/a>aafes loan payday<\/a>advance cash net payday usa<\/a>cash advance loan payday internet,cash loan payday,instant cash payday loan<\/a>cash until payday loan<\/a>payday loan on line<\/a>emergency loan payday<\/a>cheap payday loan<\/a>payday loan uk,loan payday uk,payday loan in the uk<\/a>payday loan company<\/a>fee loan low payday<\/a>payday loan calculator<\/a>fast easy payday loan<\/a>bad credit guaranteed loan payday<\/a>fax loan missouri no payday<\/a>payday loan in georgia<\/a>advance fax loan no payday<\/a>payday loan store chicago<\/a>default on payday loan<\/a>canadian loan online payday,canadian payday loan<\/a>approval guaranteed loan payday<\/a>payday cash loan,loan payday,payday advance loan<\/a>cash fast loan payday<\/a>chicago in loan payday store,chicago loan payday store<\/a>advance cash loan payday today,payday payday loan cash advance loan,advance cash loan payday<\/a><\/u> a bit of sed and grep magic I had a file which contained merely the relevant inserts. It’s still running slow, but it’s running a lot quicker than previously.<\/p>\n I know postgres’s dump functions tends to prefer COPY rather than INSERT because it is so much quicker, but that’s the point at which my familiarity with the COPY command ends, and I certainly didn’t want to spend the time to mangle the SQL I have into a couple of COPY commands.<\/p>\n","protected":false},"excerpt":{"rendered":" During the initial import of data to the {{post id=”jabbermetanetnz-has-moved” text=”new jabber.meta.net.nz server”}}, I noticed that the roster information failed to be migrated if I was using an ODBC backend – it would just fail entirely. I didn’t think too much of it until I tried to restart ejabberd, and noticed that it spent around […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[13,6],"tags":[],"_links":{"self":[{"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/posts\/59"}],"collection":[{"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":0,"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.meta.net.nz\/~daniel\/blog\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}