sirmanson

This depends on TONS of different things, but here are a few to watch our for : 1) Your server - Is it shared amongst other users? How fast is the CPU/Disk/Memory? 2) How well optimized are your queries, table structures, indexes etc.. 3) Are you using persistent connections? 4) Do you have other applications running on the server?

You should probably create another table that just keeps track of which suppliers stock which products. Since you have a \"many-to-many\" relationship it should not be stored with your products.

I don\'t believe this is possible in one query. I scoured the mySQL page and couldn\'t find anything about this. I know it is definately possible using oracle, but not currently in mySQL. You could easily parse this recordset into PHP and get what you need.

What operating system are you running?

I\'m not following what you mean? If the user visits then their record would not get archived. Basically the live table would have all of your \"fresh\" records and the archive would have everything else. If you needed to do some sort of reporting on all of the customers you could just UNION the two tables.

The easiest way to make this work is just to use a common database between the two servers. Have all of your user session data stored here. Then either server can access the data at any time.

You can order by any formula you wish Either of these will work : select col1, col2/col3 from table order by col1/col2 or select col1, col2/col3 from table order by col2/col3

Referrers ------ This is the easy one. I would archive everything from this table into another on a daily baisis. Make sure that you are running all of your stats out of the archive table so you don\'t degrade the \"production\" performance. Customers -------- I would pick a field like last_visit and prune everyone that hasn\'t visited in XX days. Move each of these records into an archive table. If you use this method you should just to a delete from the archive table for each record that exists (and is moving) from the live table. This will keep you from getting duplicate records in the archive.

There is a hot backup plugin available for mySQL http://www.mysql.com/press/partners/release_343.html Since the mySQL databases are stored as files on the server you could also setup something yourself to archive the files somewhere else every so often. http://www.mysql.com/doc/en/Backup.html

You can also specify the Column names in a list first and use the values statement ie : insert into table (id,name) values (1,\'Me\');

The way they are doing that is by creating a folder and putting an index.php in it. Example : www.webglimmer.com/community would be showing www.webglimmer.com/community/index.php

I would recommend storing some sort of access level in your tables and letting mySQL filter the results based on that. select t1.*,t2.*, t3.* from table1 t1, inner join table2 t2 on t1.id=t2.id inner join table3 t3 on t2.id=t3.id where t1.user_level<=$user_level and t2.user_level<=$user_level and t2.user_level<=$user_level order by t1.date_published

You need to use an outer join : Here is an example SELECT e.id, e.posterid, e.titletext, m.username FROM phpnews_news e LEFT JOIN phpnews_posters m ON e.posterid = m.id ORDER BY e.id DESC This will pull all of the data from phpnews_news and only the records in phpnews_posters that match. If you wanted to reverse this (pull all from posters and only those in news that match) you could change it to a RIGHT JOIN http://www.mysql.com/doc/en/JOIN.html

There are a few addons that you can purchase that support ASP on unix. The one that I thought looked best was Chilisoft!ASP (I think SUN now owns this.

MySQL does support referential integrity and cascading deletes/updates etc as you asked. It only supports it for certain table types, so be careful of that. If you would like to read more about it visit http://www.mysql.com/doc/en/ANSI_diff_Fore...reign_Keys.html

I know that the new Dreamweaver MX 2004 will allow you to connect to a mySQL database via your forms without much of a problem. http://www.macromedia.com/support/dreamwea...ysql_config.htm