Subject | RE: [firebird-support] Classic Server |
---|---|
Author | Maya Opperman |
Post date | 2011-06-21T05:42:38Z |
>>recollection is that Classic processes do not influence each other so if oneCorrect
>>of the ugly reports is run, the other users won't be affected.
>>I have to stay with FB 32-bit for now until II was in the same boat. Managed to find replacements for all the FreeUDFLib functions I was using with Fb 2.1.
>>can replace the few FreeUDFLib functions used in the database. I may try to
>>do this before they bring up the new server so I can use FB 64-bit.
>>And with Classic you can't performWhy do you say that, I do backups and restores over the network all the time with classic
>>backup/restore programmatically over the network, you have to be local on
>>the server.
I did find that with Fb 1.5 with classic I needed to put quotes around things that I mustn't with superserver, but with FB 2.1 I no longer need to do that.
>> It looks like Classic can handle multiple CPUs better than SuperserverYup, that's why its popularity returned, even though the technology is older.
>>and events can't be used if the server is behind a firewall orAFAIK, this is the same whether you're using CS or SS, but I haven't done much more than just play around with events a bit
>>secure tunnel. (everyone is on the same side of the firewall in this case)
>>It would be nice hear of anyone with experience between moving between theI used the 2 interchangeably for several years.
>>two architectures and if there is anything else I need to be aware of.
If you created your database with the superserver default page size of 3000, then you should change it to the classic recommendation (between 75 and 150) especially if you have lots of users, else it will use too much memory, and slow things down during busy periods.
Your Delphi component set should have a database properties component which will help you view and change that setting easily.
One other thing I have found, is that developing on classic is a little more difficult. We use IBExpert to modify stored procedures for a lot of our reporting, and classic server is a lot more sensitive to procedures being in use when you try modifying them. You get an error "Object is in use" and you have to go check all your connections, and make sure they're all disconnected, before you can make the change. (sometimes Delphi connects at design time, so don't forget to check that one too)
Cheers
Maya