Re: [PHP-DB] How to speed up querries in a humangous db?

2001-12-25 Thread Miles Thompson
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

[PHP-DB] How to speed up querries in a humangous db?

2001-12-25 Thread Andy
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

[PHP-DB] MyODBC problem with MySQL and ACCESS

2001-12-25 Thread Andy
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