1600 Manufacturers

[jsergneri]

Hello,

I'm building a used book store. I decided to use manufacturers as authors, using only their last names.

I've finished uploading my inventory and have 1,616 manufacturers. Many are used across various titles/categories etc.

In my test system, response time isn't an issue, so far.

 

Does anyone have a feeling or some data on if OSC hits the wall when the manufacturers goes beyond X? As we load a few 10's of books a day, I wonder if my design decision is sound.

 

This is a hosted VM Linux box running MYSQL.

The indexing appears sufficient out of the box:

PRIMARY PRIMARY 1616 manufacturers_id

IDX_MANUFACTURERS_NAME INDEX 1616 manufacturers_name

 

I use the same tiny, white GIF image for all of their images as I don't need any other data.

 

TIA,

JS

[♥geoffreywalton]

mysql will handle tables with millions of records.

 

I suspect the question you need to ask is, is your server powerful enough?

 

G