Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Great software, only one thing about the ODBC

forums › forums › SQLyog › SQLyog Comments › Great software, only one thing about the ODBC

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 10, 2003 at 2:59 am #7672
      lmch
      Member

      first of all, thank you very much for your great software.

      it is very good with very convenience and powerful.

      thanks again.

      I just want to mention one point about the ODBC import function.

      I try to import a Access 2000 database about 800M size. it takes me about two hours or more. my box is a dell P4 (1.7MHZ), 512M sdam, 7200rpm harddisk. 😎

      on the other hand, when i import mysql database into Access 2000 in the Access 2000, it just takes me severl mintus (same size).

      My question is: why there is so big different?

      thank you!

    • February 11, 2003 at 9:21 pm #13689
      Ritesh
      Member
      Quote:
      My question is: why there is so big different?

      ODBC Import is done in three steps.

      • Retrieving the data from the source

      • Creating insert statement

      • Inserting the data in target datasource

      Quote:
      on the other hand, when i import mysql database into Access 2000 in the Access 2000, it just takes me severl mintus (same size).

      It might be that when we are retrieving data from Access, Access is taking more time then MySQL to parse the query and return the data whereas MySQL is doing it ( obviously !!! ) more quickly. Therefore the time difference in importing same amount of data.

      Hope it helps.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.