[Dorset] Xed V's Mousepad
Morning all I have been trawling through an old MySQL database and as it archived Archive Manager was using Xed to look at the file, but it was so slow. I extracted the file and then open it again in Xed and it was slightly faster to scroll through. In the end I did a simple CTRL-A of the whole data base and then copied and pasted it into Mousepad and it was way faster (I am not wanting to keep the data in MySQL format, just after some raw text). Was it faster pasting it into Mousepad simply because I had copied the text out and into Mouse pad and xed was dealing all the SQL stuff. For reference I am on an i7 with 16gb of memory running Mint XFCE, all data is stored in my homeĀ folder which is on am SSD. I know I could of entered the dark arts of CLI editors but my fu is lacking in that department Tim H -- Next meeting: Online, Jitsi, Tuesday, 2021-08-03 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Xed V's Mousepad
On Sat, 31 Jul 2021 10:31:41 +0100, zir...@xendistar.co.uk said: > I have been trawling through an old MySQL database and as it archived > Archive Manager was using Xed to look at the file What format is the file? (Hint: at command line, type 'file filename') > In the end I did a simple CTRL-A of the whole data base and then copied > and pasted it into Mousepad Presumably you selected the whole of the database dump file rather than the database? > Was it faster pasting it into Mousepad simply because I had copied the > text out and into Mouse pad and xed was dealing all the SQL stuff. I've never used (or even heard of) Xed before today, but it doesn't seem to deal with SQL. Do you mean syntax highlighting? If so, it's possible - syntax highlighting will have a processing overhead, although I don't know how efficient Xed is at doing that. Some editors (eg, vim) will only process syntax for what's displayed; others will parse the whole file. The latter approach will clearly be slower on initial load, but faster to scroll. How big is the dump file? -- Great music, chat and even some wit. Join me every Friday evening at 8pm for Keith's Music Box: Follow: https://www.facebook.com/KMBEngland On Friday go to: https://www.mixcloud.com/live/KeithsMusicBox/ -- Next meeting: Online, Jitsi, Tuesday, 2021-08-03 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk
Re: [Dorset] Xed V's Mousepad
On 31/07/2021 11:05, Keith Edmunds wrote: On Sat, 31 Jul 2021 10:31:41 +0100, zir...@xendistar.co.uk said: I have been trawling through an old MySQL database and as it archived Archive Manager was using Xed to look at the file What format is the file? (Hint: at command line, type 'file filename') Once unarchived it is a .sql file, although I have found I can now open the file directly in mousepad which for some reason it would not let me earlier In the end I did a simple CTRL-A of the whole data base and then copied and pasted it into Mousepad Presumably you selected the whole of the database dump file rather than the database? It was a table dump I copy and pasted Was it faster pasting it into Mousepad simply because I had copied the text out and into Mouse pad and xed was dealing all the SQL stuff. I've never used (or even heard of) Xed before today, but it doesn't seem to deal with SQL. Do you mean syntax highlighting? If so, it's possible - syntax highlighting will have a processing overhead, although I don't know how efficient Xed is at doing that. Some editors (eg, vim) will only process syntax for what's displayed; others will parse the whole file. The latter approach will clearly be slower on initial load, but faster to scroll. How big is the dump file? Quite small, the gzip file is only 1.5mb The SQL file is from a blog which I broke when I moved hosts, so I am just dragging the raw blog text to rebuild the pages, I have all the text for the pages now just have to tidy it (remove HTML) then I can report, I have recovered and reposted about 80% of the posts already, just this last lot to do. I have never heard of Xed, looks like it a stand alone program and not bundled with archive manager, just seemed very strange for one text editor to struggle handling the .sql file while another was happy to handle it. Tim H -- Next meeting: Online, Jitsi, Tuesday, 2021-08-03 20:00 Check to whom you are replying Meetings, mailing list, IRC, ... http://dorset.lug.org.uk New thread, don't hijack: mailto:dorset@mailman.lug.org.uk