[firebird-support] Re: Firebird Embedded on web hosting

waow ! i have learned something today :) i didn't know that envirenment options are associated to the process and not to the machine . anyway many many thanks it's solved now ... finally :) if anyone else have this problem maybe in the future, this is what worked for me /*this

RE: [firebird-support] Slow Query

Stef, > Can somebody please have a look at this query and let me know how I can > improve the performance (10 seconds execute time) You are processing the Journal table 3 times, for no real benefit AFAICT. BTW, what fields are indexed, in what combinations? To your question, how does this work

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Thanks for all the suggestions so far. We have already put some of our clients computers on UPS. I'm still interested in other settings we can enable (or disable) to make the database server more robust without having to add a UPS. Glenn Thomas Hvidsten From: firebird-support@yahoogroups.com

[firebird-support] Slow Query

Hi All Can somebody please have a look at this query and let me know how I can improve the performance (10 seconds execute time) with DateSource(suppid, ddate, source2) as (select distinct suppid, ddate, source2 from journal

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

On 22/09/15 10:31, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: > Thanks for all the suggestions so far. > We have already put some of our clients computers on UPS. I'm still > interested in other settings we can enable (or disable) to make the database > server more robust

RE: [firebird-support] Support for OS X 10.11 El Capitan

RE: [firebird-support] How to Extract Filename from file path inside a stored procedure?

Mark, Thank you and the other gentleman that replied as I was able to create my own SP to do exactly what I needed to do and it works in both version of Firebird. Mike