I am a web designer from the Netherlands. I’m kind of new to creating web applications from scratch, I always used CMS and configured them.
I am creating an auction site in php / mysql which is complete. I recently read several articles on storage engines.
I have a few questions that bothered me for a while:
Which storage engine is best for my site, I use myIsam, innodb, etc.
The website I create is an auction site, it has to deal with several reading and writing EVERY SECOND !! He must check whether auctions are open, closed, paused, current price, etc.
I know that not all tables in my database will be available, it is only 3. Currently they are all myIsam. It's good? should i change them all? Change no? I really don't know what to do. I change them, this will greatly affect my site. And finnaly these changes will be applied easily, or difficult to make.
Another question I have regarding caching systems.
I also read a few about them, but I don’t know if they apply to the website that I have. The data that I get from the database changes a lot. Is it convenient for me to cache them? For example, an auction can be cached because not all items change. But the auction will not be there forever, in a few hours it will leave.
, - , . , , , .
, , , , , , .