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
wrote:
> Hello,
>
> I'm a web developer and I'm developing a web application on Rails. I'm
> gonna use MySQL at production (I'm u
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 Server
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
> maintai
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
Hi Satendra,
On Jul 14, 2014, at 3: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 (i
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;
+--+---
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:
http://www.markleith.co.uk
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. wrote:
> Would you try this?
>
> CREATE PROCEDURE `reset_sortid` (IN category INT(11))
> BEGIN
> SET @a = 0;
>
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 cac
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 sug
10 matches
Mail list logo