To help with that we'd have to know how your queries are phrased. Please
show us.
Are you having to do a type conversion on the tinyint field?
Miles Thompson
At 02:07 AM 12/26/2001 +0100, Andy wrote:
>Hi there,
>
>I have a huge table with over 2 million entries. It takes to long to make a
>qu
Hi there,
I have a huge table with over 2 million entries. It takes to long to make a
querry. No I am thinking about the datatypes. Maybe there is a better way. I
have already indexed the search fields ( which made the table 75 MB big!!!)
My table looks like that:
field1 : varchar100
field2 : c
Hi there,
I would like to transfer data from ACCESS via MyODBC towards a MySQL DB.
Reading works fine.
While writing I have a problem with data types. Not all datatypes seem to
fit. What are the proper datatypes I need to have in order to manage the
transfer?
Text does not work. I transfered it