February 28th, 2000, 07:08 PM
I need to developp a small but flexible application for an estate agency. I was thinking about using PHP and mySQL. The database will include the basic fields (such as address, rooms, city,...).
1.- What could be the size limitation in terms of number of records ?
2.- is there any script already available for this ? (need to post, read, modify and delete row in database)
Any advice regarding choice of technology (PHP/mySQL or ASP)?
March 1st, 2000, 10:11 AM
The size limitation isn't so much on the number of records but on the total size of the tables/database. My understanding is that tables can be several gigabytes in size. It is very unlikely that you will get anywhere near this with your application.
My site (www.hotlinecentral.com/hlsearch.shtml)utilizes a MySQL database with up to 500,000 records that include file names and directory paths. The limitation that I've run up against is the speed of searches when looking for a string in a text field. I've increased my RAM to 1 GB, turned off paging and normalized the database and now everything works pretty smoothly.
I selected PHP/MySQL for two primary reasons:
1. Price. They are "free".
2. Unix compatibility and stability. I use Perl to modify/maintain the database and some Perl functions won't work on NT. I work with NT and find it unreliable in comparison to Unix.
In my opinion, the primary advantage of ASP over (older versions of) PHP is session variables, but PHP4 will provide this means of maintaining persistent data during sessions, although perhaps not persistent objects.