How big do I need ....

Good question. It depends on what you are going to be storing.

To use as a guideline, here are some of my database sizes.

• A retail site I have as 90 items in its database. The size of this one is 200KB.
• My personal site has a database for storing visitor information. It's 41.5 MB after storing information on over 16,000 hits (over the coarse of a few months).
• It looks like the biggest database I have is the GeoLite Country DB. It's 79.4MB for over 1.9 million records.

conrad;218814 wrote: dunno why are you using an inferior database?

:confused:

conrad;218821 wrote: and I'll add like ms access is easy to access and hack. So, although pro ms they do have a product that sucks

First of all, OP wasn't asking if MySQL is a good DB or not. Second of all, if you are going do slam MySQL and promote others, how about if you post some data to support your theory?

I sure have had my experiences with Oracle, and not very good ones mind you. I took a class on it this semester, and we were having problems with the DB server so bad, the school's DBA couldn't fix it. Oracle's cryptic error messages were enough for me to say "no more". MySQL is simple and easy to use for me as I've used it for years.

By the way, MS Access is fine and dandy if you have to be locked into MS technology. MySQL and even Oracle works cross-platform. You can't even find a good Access connector that works outside Windows, and sense most web servers run Linux, that would not be a good db choice.

conrad;218830 wrote: Ohh, don't get me started. Ooops too late.

MS Access handles a max of 20 people so is not realistically useable as a database. MySQL is not cross platform like you mentioned it only runs using an apache server and not IIS.

With regards to a good db access connector, have you never heard of ADO? Connects to the majority of databases.

So with all due respect, I challenged why he was using an inferior product. Makes people think and reflect, maybe you should do it once in a while before shooting your mouth off.

Call it what you want. I was just challenging you to provide some actual information instead of shooting your mouth off.

With that in mind, when I meant cross-platform, I meant operating systems, not web server applications.

Also, ADO is a MS connector and thus is only able to be used in Windows. My original point was that Access DBs is difficult to access outside of MS tools. I found one out there that allowed me to connect to Access DBs from Java under Linux, but it was expensive and still under development.

Well, if MySQL is full of bugs, I've never found any. I've only gotten a corrupted table once. Have you had instances where MySQL has failed you? (like crashes related to bugs, consistently corrupting data, etc)

Again, you are quick to badger and slow to provide facts. Has MySQL failed you? How? What were you doing? By calling me a student, are you assuming that I have no real world experience?

How has MySQL failed your needs? I would like to know. If you think I need to be educated in this area, how bout you help me out instead of saying how much I have to learn? It seems you get more enjoyment out of just putting me in my place or something. I'm willing to learn.

You still have yet to back up your original post in saying that MySQL is inferior. If you are bored of it already, then perhaps you should not consider engaging in a conversation until you are prepared to back up your points (IMHO).