Hi I’m working on an application that’s is object oriented on the database structure, and since its growing large on the rows (millions of them) I wonder if its any differences in better performances between running the msyql server on a VMware or as a physic box?
just to give U a clue how my database structure is, here is a example:
table: objects
id, type_id, parent_id
table: types
id, name, …
table: properties
id, type_id, name, display_name …
table: values
id, object_id, property_id, value
I’m open for suggestions on how to optimize for better performance, thnx