I have a mysql DB that has just over 10k records across two tables with some fields being encrypted.  The server is virtual, 4GB of RAM and 1 CPU.  I need to export the records so they can be imported into another system.   I have a query I want to execute and sort by when the record was created.  When I tried to do this the CPU spiked to 100% utilization for several minutes and I eventually killed the query; I did have the query limited to just return 20 results.  



Is there a better way to get the data out; e.g. should I export the database?  Will that be just a CPU intensive?

1 Comment   [ + ] Show Comment


  • If the target is another system, rather than a report, why bother sorting? Did you try without sorting?
Please log in to comment

There are no answers at this time


Answer this question or Comment on this question for clarity