|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
July 15th, 2003, 07:18 PM
|
|||
|
|||
|
Which database is this forum running on?
I have a couple of database questions which hopefully someone can answer. I am new to databases, & am trying to figure out which database is best for what kind of project.
1) First off, what kind of database is this forum running on? I would imagine MySQL or Oracle. 2) Could MySQL handle something as big as Ebay, or would this be Oracle? 3) I have a MySQL database, which has over 200 tables, each table having over 100 fields each. Every time a webpage is loaded, a perl script queries 4 fields in each table to produce a webpage. Would it be quicker to have 1 table with 2000 fields (if even possible) queried once? 4) I have heard Frontpage can query from MS Access. How is MS Access compared to MySQL? Thanks in advance!
|
|
#2
July 16th, 2003, 03:49 AM
|
||||
|
||||
|
Hi, first of all, FORGET ABOUT ACCESS, it's a personal DB, not really suitable for anything else (but pretty powerful on my desktop).
Then read this thread about speed of this forum. Another thread to read is this about MySQL under heavy load. There is a wonderful comparison between MySQL and Sybase in MattR's signature!!!
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Which database is this forum running on? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
