Re: Another 3d model editor

[Timothy Graupmann]

Reggie Burnett wrote:
> While this is interesting and I'm sure everyone
> here wishes you the best in your work, this is not
> an appropriate place to post something like this.
> This forum and the corresponding mailing list are
> for issues people are having with Connector/net.
>
> Thanks for your understanding.
> Reggie


No problem. This app relies on Connector/net, which I have some performance issues with.

I need to be able to input 7500 polygons, 7500 vertex normals, 7500 vertex colors, and 20k indices in 1 second to start with.

So far to increase performance I've tried the following:

- First of all, I have created the proper indexes.
- I used short index names to get a perf boost per MySQL documention
- I lock the table before inserting or selecting a large group of records using the following (Is there a better way?)

IDbCommand myCommand = myConnection.CreateCommand();
myCommand.CommandText = "LOCK TABLES tagml_vertex3d WRITE";
myCommand.ExecuteNonQuery();

foreach(Vertex3d newVertex3d in vertex3dList)
...
myCommand.ExecuteNonQuery();
....

- I unlock the table afterward (Is it possible to unlock just a single table?)

myCommand = myConnection.CreateCommand();
myCommand.CommandText = "UNLOCK TABLES";
myCommand.ExecuteNonQuery();

Are there any other peformance improvements I could do? Using MySQL 4.0. Connector 1.0.3.