Query time taken on disk

2014-07-14 Thread Satendra
Hi there, I'm struggling to find the total time taken by a database query on the disk? As I understand when a database query start execution it takes some time inside the database engine some time to seek the result from disk (if that is not in cache/buffer) Can anybody from the group please

Re: Query time taken on disk

2014-07-14 Thread Reindl Harald
Am 14.07.2014 12:48, schrieb Satendra: Hi there, I'm struggling to find the total time taken by a database query on the disk? As I understand when a database query start execution it takes some time inside the database engine some time to seek the result from disk (if that is not in

Re: Stored Procedure help

2014-07-14 Thread Keith Murphy
I would second what m. dykman says. There is no reason I can think of that you would even be doing the order by clause. keith On Sun, Jul 13, 2014 at 11:16 PM, yoku ts. yoku0...@gmail.com wrote: Would you try this? CREATE PROCEDURE `reset_sortid` (IN category INT(11)) BEGIN SET @a

Re: Query time taken on disk

2014-07-14 Thread Keith Murphy
Satendra, Google show profile as it may give you all the information that you need. There is a lot more details in the performance_schema if you want to dig into it, but it can be quite difficult to get out. Here is one place to start if you want to pursue that angle:

Re: Stored Procedure help

2014-07-14 Thread Anders Karlsson
The order makes quite a big difference, actually. In this case it ensures that the ordering of the values in the sort_id column is maintained, even though the numbers are different. Say this is your data (I have ignored the category thingy for now): SELECT id, sort_id FROM documents;

Re: Query time taken on disk

2014-07-14 Thread Morgan Tocker
Hi Satendra, On Jul 14, 2014, at 3:48 AM, Satendra stdra...@gmail.com wrote: Hi there, I'm struggling to find the total time taken by a database query on the disk? As I understand when a database query start execution it takes some time inside the database engine some time to seek the result

Re: Query time taken on disk

2014-07-14 Thread greg . lane
Hi Satendra, On 7/14/2014 5:48 AM, Satendra wrote: Hi there, I'm struggling to find the total time taken by a database query on the disk? As I understand when a database query start execution it takes some time inside the database engine some time to seek the result from disk (if that is not

Re: Stored Procedure help

2014-07-14 Thread Mogens Melander
Anders, I didn't see that at first, but now. I'd agree. Maybe I should read up on stored procedures. On Mon, July 14, 2014 16:25, Anders Karlsson wrote: The order makes quite a big difference, actually. In this case it ensures that the ordering of the values in the sort_id column is

Migration from SQL Server

2014-07-14 Thread Felipe Coutinho
Hello, I'm a web developer and I'm developing a web application on Rails. I'm gonna use MySQL at production (I'm using Amazon RDS with MySQL) for this app. But this app already has a version of it (developed at ASP.NET) at production using SQL Server. Now I need to migrate the data from SQL

Re: Migration from SQL Server

2014-07-14 Thread Carlos Proal
Workbench provides some migration features and supports SQL Server http://www.mysql.com/products/workbench/migrate/ On Mon, Jul 14, 2014 at 4:47 PM, Felipe Coutinho felipelcouti...@gmail.com wrote: Hello, I'm a web developer and I'm developing a web application on Rails. I'm gonna use