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
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
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
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:
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;
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
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
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
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
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
10 matches
Mail list logo