Apparent Write caching slowing performance...

Hi, I'm having some serious performance issues that are stemming from MySQL writing data to tables. MySQL seems to cache writes, then write the block all at once. The major issue I'm having with this is that it when it does this it stops processing other requests until it's finished. I have listed

Creating a fixed length char field...

I have a question regarding fixed width char fields. How do you create them in MySQL? When I create a table and define a field MyField char[50], when I run the describe table, the field shows up as a varchar. Thanks, -- Jason H. West Software Engineer Softek Software International, Inc. 813 Pavi

Searching on indexed char field...

Does anyone know of a way to speed up seek time when selecting based on an indexed char field? I have a query that I'm executing ('select * from Table where UserName = myname') and it takes approximately 7 seconds to execute this 1000 times (UserName is char[50], and it is indexed). If I change the

Inserts slowing down as record count increases...

Hi, I have a pretty significant problem when inserting records in to 2 tables (Parent/child). In the Parent table the records are 25 bytes, and the child records are 80 bytes. The Parent table has an auto inc field which I retrieve using 'mysql_insert_id()' to populate the ownerID in the child tab