INSERT performance

2004-01-21 Thread Priyanka Gupta
Hi, I am trying to find out that if I have a table without any Foreign keys and I am doing a lot of Inserts to it, should the performance be different if I have indexes or not? If I don't have any indexes, shouldn't I expect the performance for the Inserts to be better than it would be if I had

Turning off caches in Version 3.2

2004-01-15 Thread Priyanka Gupta
Hi, I would like to turn off caches completely to do some performance testing. I have version 3.2 of the mysql server installed. Could you tell me how can I achieve this. Thanks, Priyanka _ There are now three new levels of MSN Hot

SQL_NO_CACHE

2004-01-13 Thread Priyanka Gupta
Hi, I am trying to do some performance analysis by trying different indexing schemes and testing how long it takes. To get consistent results, I would like to use something like SQL_NO_CACHE. However, the mysqld version that I have installed does not seem to support it..its 4.0.16 Could anyone

Auto increment sequence

2003-10-27 Thread Priyanka Gupta
Is there a way in mYSQL to just define an auto increment sequence rather than defining a field inside a table which is an auto increment. Bsically I need some functionality similarto that in ORACLE where CREATE SEQUENCE seq INCREMENT BY 1 START WITH 1 MINVALUE 1; basically creates a seq that inc

C API

2003-10-20 Thread Priyanka Gupta
Is there a way to have a common C API for MySQL and Oracle. I am writing some software that I would like to work with both MYSQL or Oracle as the backend server? priyanka _ Enjoy MSN 8 patented spam control and more with MSN 8 Dial