Export to text file very, very slow

10-11  Source: Network gathering  Views:0 

Advertisement
Hi, I am running 2.1.0.63 and doing an export of a query to a text file. The export was 66000 rows, but took incredibly almost around 2 hours to finish. The row counter in the status bar was very slow. The same exact query/export under 1.5.4 ran in about 5 mins. The row counter on both the fetching and exporting was just flying by.
Has anybody else experienced this ? What could be causing it to run that slow under this release ?
The other issue I have is once there has been no activity for a while, sqldeveloper hangs has to be restarted. I saw this being addressed in another post however, and will follow it there.
Any ideas on when a patch will be made available to this release ?
BTW, I really like some of the other new features of this release.
Thanks,
Mark
Ok, I think the issue was that I was exporting to a shared network drive. I redid it, saving it locally and it worked fine.
I still have the issue of inactivity and having to restart sqldeveloper.
Thanks.
Related articles
  • Export to text file very, very slow 10-11

    Hi, I am running 2.1.0.63 and doing an export of a query to a text file. The export was 66000 rows, but took incredibly almost around 2 hours to finish. The row counter in the status bar was very slow. The same exact query/export under 1.5.4 ran in a

  • Export to Text File Slow 10-11

    Post Author: shfisher CA Forum: Older Products We have a fairly complex report written in Crystal 8 that displays within seconds in the viewer.  A user routinely exports this report to a text file, and until approximately three weeks ago, the export

  • Read from text file takes very long after the first time 10-11

    Dear LabVIEW experts, I'm having a problem with read from text file. I'm trying to read only every nth line of a file for a preview with this sub vi: I seems to work well the first time I do it. The loop takes almost no time to execute an iteration.

  • Manual Export to Text files 10-11

    Hi all, I have done the logic to manually export oracle data to text files through java classes. but when we tried to execute the script in test server, there were some column values missed out. I have used the very basic procedure. "SELECT * FROM ta

  • Export to Text File 10-11

    Post Author: hepburn CA Forum: Exporting I'm using Visual Studio 2005 Team Suite which I believes has Crystal Reports 10 installed.I'm trying to export to a text file. Here's the code I have so far:        DiskFileDestinationOptions diskOpts =       

  • Export to Text file does not page 10-11

    Since I applied SP 7 for Crystal 9, when I export a report to a text file it does not page and print the report header on each page. It prints the report header once and one lone continuous page of information. My report was export to text with a pag

  • Problem with alv output export to text file 10-11

    hi experts, when iam exporting alv output to text file, some data is missing in text file.say for example sold-to-party value is 1155027 in alv out put,but in text file it is showeing only 115502 , the last digit is missing, can anyone help urgent!!!

  • Add/Remove Programs - export to text file? 10-11

    Hello, I am wondering if it is possible to export a list of everything in add/remove programs to a text file for inventory purposes. I have not found any easy method to do this short of copying reg files or installer 3rd party software.  Since the id

  • How do I export to text file and suppress the cr-lf at end of row? 10-11

    Hello. I have created a report that is mean to export to a text file.  It will always be a 1 row report and it's always going to be uploaded to a vendor via their website.  They don't want the cr-lf at the end of the row. I can't figure out how to ge

  • How to export to text file without ruin the format 10-11

    Hi guys, I need some help here. My company recently come with the decision to print the mainframe report file that usually come as a text file, to a virtual printer. This virtual printer is printing the report as Adobe PDF format. The problem is, my

  • Can I Export to Text File? 10-11

    hi, can i export my ical events to a text file? thanks. samanthaI have figured out a way to do this with free available programs: Download this program: http://www.nirsoft.net/utils/faview.html Faview will allow the bookmarks exported in html format

  • Export to text file shows extra character at line 60, 120 so on 10-11

    Hi, I am using Crystal report 13 with .net 4.0 ( Visual Studio 2010) I have an issue while exporting from CR to Text file, After every 60 lines some special character is inserted in the text file. That might be the new page character. Is this the lim

  • Export to text file/sqlfile 10-11

    I would like to export my oracle 10g DB to text file /sql file in order to import into Mysql db. suggest me how to do it. thanks in advance.In 8.5 the default behavior of the export to text was to not paginate. With 9 you have a paginate option when

  • Export to text file cuts off data... 10-11

    I have a report that contains fixed width formuals that are in a text box.  The data is 496 char wide.  It will preview fine in a small font - but when I export to a text file it re-sizes the font to courer new 10 and cuts off data after 80 char.  An

  • Export to text file fails 10-11

    Hi I'm using Designer 6i (release 2) on NT. When I try to export to a text-file nothing happens. This only works if I choose a container and not for a object at a lower level. null<BLOCKQUOTE><font size="1" face="Verdana, Arial, He

  • Lost decimal point after export to text file 10-11

    Dear All, I have problem which to beset me long long time. I haven't dug the cause yet. Actually, I have a program which will generate a text file in background everyday. The text file included po data which is create last day, such as po no, item, u

  • Custom export to text file 10-11

    Scott (Spendolini) and Carl: I put Scott's blog entry at http://spendolini.blogspot.com/2006/04/custom-export-to-csv.html and Carl's example at http://htmldb.oracle.com/pls/otn/f?p=11933:69 together at http://htmldb.oracle.com/pls/otn/f?p=24317:117 B

  • Export to text file only one big page 10-11

    We currently have an application that was developed in VB6 that calls a number of Crystal Reports RPT files. These Crystal Reports RPT files were developed in Crystal Reports 6. The problem is that when exporting to TXT format only 1 big page is show

  • Crystal Report 2008 export to text problem 10-11

    Hello, I am using Crystal Reports 2008 for generating reports in our WPF application. In this application, we are exporting the report to txt file on a button click. Now the application contains a form called u2018Print Manageru2019, through which th

  • Strange character appear when writing to text file. 11-30

    Hello, I am facing some problem when I read some data from and binary file (.dat) and then saving them into text file. When I convert those data into string and then write to a text file. Some strange characters were found in the file when I opened i