[noblenull]

'Khushboo' wrote on '03:

The issue is with views containing OUTER and INNER JOINS and with large data.

This problem also occurs when querying the tables directly, without the use of the view.

[noblenull]

'peterlaursen' wrote on '27:

OK .. somebody with better insight to ODBC than me will have to look into this!

Peter,

Any update on this?

Thank you.

[noblenull]

'peterlaursen' wrote on '27:

1) Are the machines on the same network or are you importing over the Internet? 

The MS-SQL source database is on the same network, the MySQL destination is over the internet. However, I can run other similar sized exports over this connection without any issues.

'peterlaursen' wrote on '27:

2) How big is that VIEW? (#of rows, the data length for the table in MySQL after import as returned by SHOW TABLE STATUS)

Rows 33060, Data Length 5429504, MyISAM

'peterlaursen' wrote on '27:

3) Can you try creating a table on source with the same data and next import just to see if it makes any difference  (not sure about SQL Server syntax but there must be something like CREATE TABLE … AS SELECT …)

After creating a table from the view, the import completes in 40 seconds with compression on (I've tried with it on and off).

'peterlaursen' wrote on '27:

If it is not a networking issue or a MySQL configuratiobn issue I am afraid we will need a complete test case with data to comment further (access to the database or a copy). Can you provide that?  And please create a support ticket for privacy when exchanging such details.

I may be able to provide this, but would have to sanitize the data.

[noblenull]

peterlaursen wrote on Sep 23 2005, 07:51 PM:

I'm sorry but I don't understand this.

Could you specify where you enter that query?/those queries?

What is the ODBCsource that you import from?

Could you paste in an example? or provide a screen-dump?

And what do you want to accomplish with that can't be accomplished by now?

[post=”7296″]<{POST_SNAPBACK}>[/post]

Say for example, I want to select a customer name based on order date.

I would do something like:

select name from customers where orderdate > '9/23/2005';

I then want to update ALL of the prices from my inventory table.

select model, price FROM inventory;

Currently, it is not possible to do both of these things in 1 job (as far as I know).

[noblenull]

When is v4.1 scheduled to be released? Can only the updated items in the ODBC source be imported, or do the tables need to be completely overwritten each time an import is run?

[Author]

Posts