A quick question for the hardcore MySQL experts out there.
I have a simple table;
---
ID varchar (PK)
DATA longblob
---
This table is a simple persistence cache for one of our servers. It
regularly INSERTs and SELECTs into this table data of approximately 2KB
-
Alan Williamson wrote:
A quick question for the hardcore MySQL experts out there.
I have a simple table;
---
ID varchar (PK)
DATA longblob
---
This table is a simple persistence cache for one of our servers. It
regularly INSERTs and SELECTs into this table data
Thanks for that Chris, interesting thoughts.
For clarification, there is *NO* UPDATEs running on this table. Not a
single one! :) Many more SELECTs than INSERTs
Chris Nolan wrote:
Alan Williamson wrote:
A quick question for the hardcore MySQL experts out there.
I have a simple table;
Hi Alan,
Thanks for that Chris, interesting thoughts.
For clarification, there is *NO* UPDATEs running on this table. Not a
single one! :) Many more SELECTs than INSERTs
If you value your data, and these INSERTs are part of
a multi-insert batch of related data, go with the table-type
that