I used to be a Lasso/FileMaker programmer. The day I decided to
switch to the all-unix MySQL/PHP/Perl platform was very telling. I
was attempting to parse log files with Lasso's file tags. Everything
was working quite well, but once the log file was bigger than about
500k, it would "hang" the system for 60 seconds or more, while Lasso
churned through the file. I decided to rewrite the script in Perl.
What took lasso (which FileMaker Instant Publishing is built on) 1 or
2 minutes was instantaneous. The same goes for FileMaker, a search
that returns more than 100 records, or inserting more than 20 records
into a single table can take eons. With PHP/MySQL, I can do a dozen
queries with complicated joins, in one script, and MySQL just spits
the data out in record time. (even on an old, crusty PowerMac
7600/132)...
I love FileMaker and will always use it on my desktop, but I have
sworn off if it on the web, it's not
meant for web-apps.
I won't even go into scalability or backups.
There are many interesting ways you could bridge the gap using
FileMaker plug-ins, or JDBC, or ODBC, to move data into and out of a
MySQL server, if you use Macs, you could even use MacSQL Monitor and
AppleScript.
Regards,
David Dahl
>This is probably heresy here, but we use Filemaker for our web-database
>solution. The main reason why we use that in preference to more 'robust'
>SQL-based DBs is that we have a team using Filemaker clients updating
>information constantly and Filemaker is the most efficient db we have found
>to do that.
>
>We are currently evaluating MySQL to see if there are any advantages in
>moving.
>
>
>Regards
>
>George Pitcher
>
>Technical Manager
>HERON Project
>Napier University
>Edinburgh EH10 5DT
>
>[EMAIL PROTECTED]
>[EMAIL PROTECTED]
>[EMAIL PROTECTED]
>
>http://www.heron.ac.uk
>================================================
> programmer - A device for transmuting caffeine into code.
>================================================
>
>----- Original Message -----
>From: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, August 27, 2001 12:50 PM
>Subject: the most used DB in Webhosting
>
>
>> Dear members,
>>
>> I know you are MySQLer but be honest, what is the the most used Database
>in
>> ISP of webhosting, and the reasons. And fornyou, after MySQL what is the
>DB
>> the you prefer in webhosting.
>>
>> thanks to all
>>
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>---------------------------------------------------------------------
>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
--
---------------------------------------------------------------------
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
