I have some general questions regarding a number of things.. I am not looking for "what's wrong with my code?" type answers, just some friendly advice from anyone who want's to answer. HEre goes:
What are the gotchas with respect to scaling? What am I going to wish I didn't do when I start getting a lot of people using the system? Are here any special issues or techniques to siimulataneous access by multiple (tens of thousands , say) of users if they are just searching and reading (SELECTING)? Has anyone ever doen anything with repsect to sclaing through distributing instances and reconciling them at specific times where perfect accuracy (timeliness, out-of-sync-ness) was NOT an issue? SO in other words they just need to be reconciled MERGED I suppose) every day, leet' say? Free form responses and off the top of head thoguhts are most welcome! -C ----- Original Message ----- From: "Cassidy Symons" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 21, 2003 3:45 PM Subject: Re: why me??! > Try explicitly stating the columns you're inserting to (IE, INSERT INTO > products (quantity, model, image, etc.)), and not inserting a value for the > products_id. If it's auto_increment, the DB sets the value for you. > > > Cassidy > > NETPACQ Systems, Inc. > "Full Service Web Media" > 5205 Kearny Villa Way, Suite 106 > San Diego, CA 92123-1410 > Voice - 1-858-541-0222 > Fax - 1-858-874-7771 > [EMAIL PROTECTED] > http://www.netpacq.com > > > At 12:35 PM 6/21/2003 -0700, you wrote: > >I'm trying to load a couple tons of data into a shopping cart system and > >for some reason it keeps kicking back with an error. I'm too dumb to > >figure out why. Can anyone tell me what's wrong with this code and why it > >doesn't work? > > > >INSERT INTO 'products' VALUES (153328, 2, '181150', 'noimage.gif', > >'154.1000', '2003-06-20 23:03:00', NULL, '0000-00-00 00:00:00', '0.00', 1, > >1, 1, 0); > > > >The table itself looks like this > >CREATE TABLE `products` ( > > `products_id` int(11) NOT NULL auto_increment, > > `products_quantity` int(4) NOT NULL default '0', > > `products_model` varchar(12) default NULL, > > `products_image` varchar(64) default NULL, > > `products_price` decimal(15,4) NOT NULL default '0.0000', > > `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00', > > `products_last_modified` datetime default NULL, > > `products_date_available` datetime default NULL, > > `products_weight` decimal(5,2) NOT NULL default '0.00', > > `products_status` tinyint(1) NOT NULL default '0', > > `products_tax_class_id` int(11) NOT NULL default '0', > > `manufacturers_id` int(11) default NULL, > > `products_ordered` int(11) NOT NULL default '0', > > PRIMARY KEY (`products_id`), > > KEY `idx_products_date_added` (`products_date_added`) > >) TYPE=MyISAM AUTO_INCREMENT=30 ; > > > >and I myself look like http://www.dibcomputers.com/images/headbang.gif at > >the moment. ;) > > > >TIA! > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
