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

Comments

  • 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

Answers

Answer this question or Comment on this question for clarity