Question on Indexing

2001-11-21 Thread Manjeet Singh
Hi Group, I am using a database and want to index it for better performance. The datatypes for the coloums i am indexing(multicolumn indexing) are: varchar and timestamp I came to know that changing the datatype from varchar to char effects the performane a lot. I would like to know, has any

Design,Performance and Speed of MySQL

2001-11-02 Thread Manjeet Singh
Hi Group, I am new to mysql, and would like you all to give some time in resolving my trouble. I am stuck up with a problem of designing stores database for a big company.The company is located in different places and wants web-based insertion, retrival and maintaining of data and records in the