Re: SCSI vs IDE

2001-11-20 Thread Frank Fisher
Thomas S. Iversen wrote: Back to the question: we're on a limited budget, and have to choose between either inexpensive but large IDE disk or fast but small SCSI disks. The machine has 1GB memory. First thought would be IDE disks since we have enough memory to cache the DBs. If you're on

Re: Info Needed to Promote MySQL!!

2001-09-25 Thread Frank Fisher
Adam Douglas wrote: 1. Replication between 2 sites via the internet over a VPN or just using a secure connection. Chapter 11 in the manual (p. 354 of the PDF). You're set. SSH will get you the secure connection. 2. Transaction processing capabilities with the ability to roll-back a

Re: Size of DB

2001-09-13 Thread Frank Fisher
Ian Barwick wrote: In Windows you can probably do something involving the mouse and some icon-thingies, or maybe a simple DIR at the command line. Right-click on the MySQL database folder, selecting Properties. Under DOS, substitute your Unix command with DIR and look at the total at the

Re: Let's approach stored procedures

2001-09-10 Thread Frank Fisher
Adams, Bill TQO wrote: The other thing about all of this is that MySQL is feature rich so most people might not have a use for stored procedures. Unlike, say, Informix which has not build in MIN or MAX function. Depending on the way you define things, MIN and MAX are essentially stored

Re: Use of the MySQL logo - licensing agreement

2001-08-30 Thread Frank Fisher
And then there's the sad situation I'm in. I'm using MySQL to do a site for the U.S. Army, but I am not allowed to put the logo up as it would be considered an endorsement of a commercial product, which is a major no-no. And I'd like so much to do it. I'm thinking of a way, but I'll have to

Re: Good references for Theory??

2001-08-23 Thread Frank Fisher
John Coggeshall wrote: Hey all I've been a bit of a dweller on this list for quite some time now. I'd like to throw a question out for all of you.. I have at least a decent understanding of the concepts behind a relational database, but I'd like a little more information on the

Speaking of tree searches

2001-08-20 Thread Frank Fisher
I have an upcoming project which will require me doing a recursive function in PHP, doing a tree calculating optimum route between defined points in the database. The function is going to have to do a SELECT on the MySQL database on each iteration. It could concievably do thousands of

Re: Speaking of tree searches

2001-08-20 Thread Frank Fisher
Hans Zaunere wrote: Maybe it's just me, but it sounds like you need to reconsider you're database structure. I can't think of any reason that such a schema would be required. It's simply a database of locations on the globe, and I need to calculate how to get to one place from another

Re: Downsides of MySQL?

2001-08-17 Thread Frank Fisher
Steve Edberg wrote: Do these people even know what they mean by 'enterprise management functionality', or did they just crib from an Oracle brochure? DO they have any specifics about what they require? Managers do that all to often when comparing software. They look at the feature

Re: Retrieving Auto-increment index after insertion.

2001-08-16 Thread Frank Fisher
Charles Williams wrote: Hello, I am trying to figure out how I can retrieve an automatically incremented index after I insert data into the table. The index is the ONLY information that is unique in the entry at times and additions are quite often. Any ideas would be appreciated. In

Re: Downsides of MySQL?

2001-08-16 Thread Frank Fisher
Boget, Chris wrote: --Begin Quote-- MySQL - as I said at our meeting, we would not be comfortable with this as an enterprise strength solution. MySQL is unsupported freeware and lacks enterprise management functionality. It has a small limited feature set compared to ORACLE, DB/2 and

Migrating to MS SQL Server

2001-08-07 Thread Frank Fisher
My company just stole my web server running MySQL. I will now have to host my site on a consolidated server that has MS SQL Server. How do I migrate? I think my SQL code will be good except for auto_increment, but are there any migration tools? Frank Fisher