RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

I don't think you realize the nature of the site. Its an auction site and not a retail site. Prices need to be updated on thousands of clients simultaneously. Our goal is to refresh the data on the client every 3-10 seconds while having 1500 online open auctions. This is quite a mess :) -----Original Message----- From: Manuel Lemos [mailto:mlemos@acm.org] Sent: Sunday, January 13, 2002 11:45 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 Hello, Boaz Yahav wrote: > > You realize that what they did will never work with an Ecommerce auction > site where everything must be in real-time... Why do you say that? Because you think you will need to handle as much requests as they do but always with upto date information? AFAIK, most of e-commerce site requests are content publishing of front store pages. Most of that can be handled with no real time database access either with static pages or cached content. Unless you are going to sell 30 million items like Amazon did in X-Mas, you won't need great hardware for that. Anyway, for busy sites is always a good idea to avoid read only database accesses or else your site will not scale. Besides content caching, it is always important to avoid database accesses for simple but repetitive things like session authentication. Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net