[FX.php List] one machine intallation

[Bob Patin]

Yes, I agree about the hassles of taking a file offline to make  
changes... I guess I'm spoiled though, since I run a hosting company  
and have all the servers 30 feet away.

So far however, with approximately 200 databases (both FM 5/6 and FM  
7 or 8), I haven't had one instance where a database was damaged  
because a connection was lost during an edit. On the other hand, I've  
had many instances where clients' connections have been dropped and  
their most recent record changes were lost...

The FMI tech stressed keeping anything else from running on the FMSA  
machine; this is a practice we've always adhered to here, and it's  
worked well. Tomorrow I'll be getting a new web server (a quad-core  
Mac Pro 2.66), and I'm eager to see if it makes a big difference in  
the speed that database queries are returned.

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060


On Apr 25, 2007, at 7:45 PM, Tom Sepper wrote:

> Oh I definitely remember the difficulties that Server 5.5 saddled  
> us with. There's definitely a happy-medium that we have to discover  
> for each of our FM solutions.
>
> For me, there's about five tables in my 80-table solution that I  
> just can't make any definition changes to while others are connected.
>
>
> Tom Sepper
> Director of Information Technology
> Director's Choice Tour & Travel
>
> P 806.762.6354
> F 806.763.7637
>
> tsepper at directorschoice.travel
> www.directorschoicetourandtravel.com
>
>
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org on behalf of Kevin Futter
> Sent: Wed 4/25/2007 7:34 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] one machine intallation
>
> On 26/4/07 9:53 AM, "Tom Sepper" <tsepper at directorschoice.travel>  
> wrote:
>
>> I can definitely see why FMI would say it's best practice to make  
>> DB changes
>> offline. I'm sure we've all noticed the annoying "bug" when  
>> duplicating
>> layouts and such. Remember that pre-FM7 that you couldn't make  
>> definition
>> changes to a live database; it had to be offline.
>>
>> A few weeks ago, I was working from home writing a pretty  
>> intricate script
>> when my Internet connection went out for about five minutes. When  
>> it came back
>> up, I tried to log onto my FM database only to see that all  
>> scripts were gone!
>> This DB file has about 600 scripts. Thank God for backups!
>>
> On the other hand, we used to struggle to maintain our databases  
> effectively
> running under the restrictions imposed by 5.5 Server, as our  
> databases are
> busy enough to make it impossible to take them offline for work.  
> This was
> especially annoying if all you wanted to do was fix a typo on a  
> layout. We
> find the whole show much easier to manage now, but I will concede  
> that there
> could be unknown negative side-effects to this approach. So far  
> though, the
> benefits far outweigh the negatives.
>
> -- 
> Kevin Futter
> Webmaster, St. Bernard's College
> http://www.sbc.melb.catholic.edu.au/
>
>
> ###################################################################### 
> ###############
> This e-mail message has been scanned for Viruses and Content and  
> cleared
> by MailMarshal
> ###################################################################### 
> ###############
>
> This e-mail and any attachments may be confidential. You must not  
> disclose or use the information in this e-mail if you are not the  
> intended recipient. If you have received this e-mail in error,  
> please notify us immediately and delete the e-mail and all copies.  
> The College does not guarantee that this e-mail is virus or error  
> free.  The attached files are provided and may only be used on the  
> basis that the user assumes all responsibility for any loss, damage  
> or consequence resulting directly or indirectly from the use of the  
> attached files, whether caused by the negligence of the sender or  
> not. The content and opinions in this e-mail are not necessarily  
> those of the College.
>
> <winmail.dat>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list