Re: multi-user database design

Most websites you typically see that are connected to large databases are using some sort of ODBC. MySQL and MS SQL are both able to multiple tables, with each tables containing not just thousands but millions of records.

These connections are usually a minimum of a 3-tier connection. The web-server connects constantly to the database server becuase it is faster than establishing a new connection every time an end user makes a query. To prevent the database from being compromised, each user's query then has exclusive right access for only milliseconds.

If you still have questions drop me a line.

Best of Luck,
Glen Salisbury
Multimedia Developer
g.salisbury_at_cross-productions.com
Cross Productions
www.cross-productions.com

racudd wrote:
>
>
> How do the likes of Amazon and Hotmail etc (anyone with loads of users)
> design their databases ? Would they set up a new database user for
> each of their customers and thus have literally thousands of users
> accessing their database at a time. Or would they have one or two
> "power" users to access their databases and retrieve all of the data
> and then pass it back to each individual user ?
>
> Also, would they use persistent db connections (with Apache and
> mod_perl or something) to increase speed or would they try and save
> some memory and just make a new connect to the database each time the
> users request information? I can imagine that persistent connections
> would limit the number of concurrent users possible due to memory usage.
> Thanks
> Richard
>
>
> Sent via Deja.com http://www.deja.com/
> Before yo

--
Posted via CNET Help.com
http://www.help.com/ Received on Thu Jan 20 2000 - 22:30:20 CST