RE: Importing data from a file

2004-10-25 Thread Brian Abbott
There's a tool called "mysqlimport". I recommend using that. Or, if you have to extract data from a larger set, you could write a program. But, mysqlimport is the easiest way. If you're on a UNIX machine, run 'man mysqlimport' for more information. Good luck, Brian -Original Message- Fr

RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

2004-09-14 Thread Brian Abbott
Also, out of curiosity, who was your vendor for the opteron? Brian -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 2:21 PM To: Donny Simonton Cc: [EMAIL PROTECTED]; 'Miles Keaton' Subject: Re: best-performing CPU + platform for MySQL n

RE: best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

2004-09-14 Thread Brian Abbott
Do you guys have metrics on this that you would be willing to share? We are looking at upgrading to the Opteron (from the Xeon) at the moment. Any information would be very helpful. Brian Abbott -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Tuesday, September

RE: What's Faster? MySQL Queries or PHP Loops?

2004-09-10 Thread Brian Abbott
I assume he means selecting every entry in a given table ("select column from table"). You should be able to easily find the answer to this by inserting some code that records times as you run. My bets are on SQL. Cheers, Brian -Original Message- From: Stuart Felenstein [mailto:[EMAIL PR