Hi Joshua,
> Making the MySQL indexes would be your responsibility. Importing the data
> would most likely not import the index definitions also. You need to
> recreate those. Your explain seems to indicate that you have *no* indexes
on
> your table. I would guess that your query doesn't hang
Please reply to the list, and not to me. Thanks.
Making the MySQL indexes would be your responsibility. Importing the data
would most likely not import the index definitions also. You need to
recreate those. Your explain seems to indicate that you have *no* indexes on
your table. I would g
Since you have used SQLyog, I will say you contact the
SQLyog people about this.
Karam
--- "Joshua J. Kugler" <[EMAIL PROTECTED]> wrote:
> You "can't?" How are you trying to display? What
> are you using? A CGI
> script? A database utility? Something else? We
> need a bit more information
>
MySQL is very stable on large databases...I would suspect inefficient indexes.
What does your query look like? What is the output when you put "EXPLAIN" in
front of your query?
I don't know anything about SQLYog blob display, so can't comment there.
j- k-
On Monday 05 April 2004 05:4
You "can't?" How are you trying to display? What are you using? A CGI
script? A database utility? Something else? We need a bit more information
to answer the question.
j- k-
On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like:
> Hello list,
> Recently I've b
Hello list,
Recently I've been in the job of migrating a large (about 1.5GB)
database build in MSSQL Server to MYSQL. The migration was done OK, I
used the "SQLYog" utility to do this. The problem is that one table has
image column types ... I tried to view this column types (blob data
types