You want to limit your web page to returning only a limited number of names like 50 or even 100. I'm sure you've seen this "interval" loading on many web sites. You actually should always set a limit on your queries, regardless of how many records you expect. I would suggest you put a set of buttons on your page containing each letter of the alphabet. That will give the user quick access to names starting with that letter.
When designing for the web you have to remember that the web is stateless by default. You don't stay connected like in FileMaker or other systems. The web server doesn't know what page it last delivered to you, you have to track this information yourself. Apache/PHP/MySQL is very different than FileMaker and there are pluses and minuses to both. A well designed MySQL database will be far more scalable than FileMaker.
Like you, I'm currently migrating away from FileMaker. I've got a few interrelated tables with records of 15K, 19K, 51K and 68K. Some things are starting to get a little slow and really shouldn't with that few records.
On Tuesday, January 7, 2003, at 11:54 AM, Lefevre, Steven wrote:
I'm migrating users from a desktop FileMaker app to an Apache/Mysql/PHP
thingy.
The opening page of the FM app has a list of all the students, in
alphabetical order. It displays rather quickly. My webpage takes a while to
load all the students -- it's like 2 MBs of data over a dial-up line!
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php