Thread: size limitation

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    France
    Posts
    2
    Rep Power
    0
    Hi,

    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)?

    thanks


    ------------------
    PG
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Englewood, CO
    Posts
    30
    Rep Power
    15
    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.

    -TM

Similar Threads

  1. Does _msize() always return EXACT size of malloc'ed block?
    By Jason Doucette in forum C Programming
    Replies: 10
    Last Post: November 29th, 2003, 01:24 AM
  2. please help
    By traixanha in forum C Programming
    Replies: 7
    Last Post: April 25th, 2003, 04:39 AM
  3. size limitation on input variables?
    By hkbill319 in forum HTML Programming
    Replies: 5
    Last Post: April 9th, 2003, 05:23 AM
  4. open file limits in apache or linux kernel?
    By eva2000 in forum Apache Development
    Replies: 1
    Last Post: July 28th, 2002, 07:39 PM
  5. size limitation of uploaded files
    By jun.wang in forum PHP Development
    Replies: 4
    Last Post: October 12th, 2000, 01:33 AM

IMN logo majestic logo threadwatch logo seochat tools logo