Home » SQL & PL/SQL » SQL & PL/SQL » Time to export data to a CSV-file
Time to export data to a CSV-file [message #206731] Fri, 01 December 2006 05:06 Go to next message
Breedsmoelkikker
Messages: 2
Registered: December 2006
Junior Member
Ik wil 300.000 records exporteren naar een csv-file.
In het verleden kon dit in 1 uur nu kan dit gemakkelijk 8 uren duren.
Heeft dit iets te maken met de versie/instellingen van SQL vroeger sql-navigator 4 nu sql-navigator 5 .
Of heeft dit iets te maken met het netwerk?
Het gaat vooral over de snelheid van de "fetching".
Aan de te exporteren records is er niets gewijzigd.


I want to export data to a CSV-file.
In the past the export of 300.000 records took 1 hour now it takes 8 hours or more.
Does the version of sql-navigator has anything to do with that or a setting, or can it be the network? In the past we used SQL Navigator 4 now we are working with SQL Navigator 5.
The records didn't change.


[Updated on: Fri, 01 December 2006 05:06]

Report message to a moderator

Re: Time to export data to a CSV-file [message #206734 is a reply to message #206731] Fri, 01 December 2006 05:19 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
It's the same query on the same data?
Are there any indexes involved? If yes, did you analyze your tables lately?

[Edit: ah, sorry, the records didn't change]

[Updated on: Fri, 01 December 2006 05:25]

Report message to a moderator

Re: Time to export data to a CSV-file [message #206735 is a reply to message #206734] Fri, 01 December 2006 05:25 Go to previous message
Breedsmoelkikker
Messages: 2
Registered: December 2006
Junior Member
The query hasn't changed.
The query gives result in 15 min. But it is the exporting of the data that takes forever.
Previous Topic: HOW TO SCHEDULE A TASK IN ORACLE
Next Topic: something about EXENT MANAGEMENT and SEGMENT SPACE MANAGEMENT
Goto Forum:
  


Current Time: Tue Dec 03 05:58:49 CST 2024