Tagged: Large file
- AuthorPosts
- June 22, 2017 at 7:08 pm #21992DavidParticipant
It’s my first time to open so big file – 12MB XML file and view/change something(want to open whole file, not partial). During scrolling the vertical bar, I find the operation is not so smooth (feel slack). Experience is not so good as it on opening small file.
I don’t know if there’s a way to improve experience? Thanks!
My laptop environment:
Operating system: Windows 7 Professional Service Pack 1 64 Bit Number of CPUs: 8 Processor: Intel(R) Core(TM) i7-4710MQ CPU @ 2.50GHz Physical total memory: 8GB HDD: SSD 128GB EmEditor: version 16.6
June 23, 2017 at 11:14 am #21993Yutaka EmuraKeymasterThe 12 MB file is very small, and should be no problem with EmEditor. Can you please disable Outline if already enabled? Can you also disable all plug-ins?
If the problem still persists, please export all settings first (Tools > Export and Import), and then try the “Reset All Settings” command (Tools menu > All Commands > Tools).
Thanks,
June 23, 2017 at 7:47 pm #21995skyParticipantSuppose it is caused by the file with very long(column) text in one line or some lines.
For example:
1,000,000 lines of “0123456789\n” , 12MB,
View “Wrap by Window” => Vertical bar is smooth; Horizontal bar is N/A.
View “No Wrap” => Vertical bar is smooth; Horizontal bar is N/A.Try to remove all “\n”, it will become 1 line of “012345678901234567890123…..”, 10MB,
View “Wrap by Window” => Vertical bar is not smooth; Horizontal bar is N/A.
View “No Wrap” => Vertical bar is N/A; Horizontal bar is not smooth.June 23, 2017 at 9:13 pm #21996DavidParticipantHello,Sky:
Yes. This file has only one row and 12,793,967 columns. It’s generated by a software. The contents are like
<ap:TaskPriority Dirty="0000000000000000" TaskPriority="urn:Prio5"/></ap:TaskPriorityMarker></ap:TaskPriorityMarkers></ap:MarkersSetGroup></ap:Map>
June 23, 2017 at 10:29 pm #21997DavidParticipantHello, Yutaka sang,
Thanks for your reply. I have done as your suggestion. But it seems same as before.June 24, 2017 at 12:22 am #21998skyParticipantWorkaround solution: find all “<ap:” replace with”\n<ap:”
EmEditor can handle many lines file easily.August 15, 2017 at 8:40 am #22242JohnQSmithParticipantOn the same lines as this. I have a 22MB XML file. There are about 94K instances of “<row>…</row>”. I am trying to split them onto individual lines.
Using EmEditor 64bit 17.0.2 in portable mode. I backed up my EmEditor folder and then “Reset All Settings” as in your post. Using the replace window (CTRL-H) with “</row>” in the find box, “</row>\n” in the replace box and “Use Escape Sequence” checked, it has been running over 7 minutes and is only up to “6300 Found, Searching line 1 / 2” in the status dialog box.
Using Cygwin64’s sed command takes less than 1 second.
10:14:33 $ time sed -e "s_</row>_</row>\n_g" sheet1.xml > out.xml real 0m0.476s user 0m0.327s sys 0m0.077s
I can email you the file for testing; it compresses to a 2.3MB ZIP file.
August 15, 2017 at 10:39 am #22248Yutaka EmuraKeymasterI tried to reproduce the issue with similar file: 22MB xml file with 94K instances of the same tag, but it took only 6.547 seconds to complete the same Replace All. However, I just noticed that the portable version will take much, much longer time to complete. I will try to fix this issue.
Thanks,
August 15, 2017 at 10:49 am #22249JohnQSmithParticipantScreen cap of my advanced settings and the sample file have been sent. Glad to hear you’ve duplicated the problem. Thanks in advance.
August 15, 2017 at 10:59 am #22250Yutaka EmuraKeymasterOK. Sorry for many revisions. I reproduced the issue if the Match Case option in the Replace dialog box was cleared as default. If the Match Case option is set, the Replace All operation will become much faster. Please set the Match Case if you try to do the similar operation. I will try to remedy the issue.
Thanks,
August 15, 2017 at 12:03 pm #22251JohnQSmithParticipantEnabling “Match Case” required only 17 seconds to complete the replace all. I appreciate your continuing support.
August 15, 2017 at 6:52 pm #22259Yutaka EmuraKeymasterHello,
I addressed this issue on beta 6, which I released just now.
Thanks!
- AuthorPosts
- You must be logged in to reply to this topic.