Picon

ANN: Video on best practices using the Trace API and FB TraceManager in high load scenarios

Hello,

the video is available here (~ 24min):
www.iblogmanager.com/download/demos/fbtm/fbtm_traceapi_fbtm_highloadscenario.htm

In this video I discuss different aspects on how to use the Firebird 
Trace API and FB TaceManager in high load (production) scenarios.

--

-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

------------------------------------
Posted by: Thomas Steinmaurer <ts <at> iblogmanager.com>
------------------------------------

Picon

SSL 3 is dead, killed by the POODLE attack

After more than a week of persistent rumours, On (Oct 14) we finally learned about the new SSL 3 vulnerability everyone was afraid of.


Security Labs: SSL 3 is dead, killed by the POO... | Qualys Community




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Node Firebird Pure Java Script driver 0.2.0 is released with many features and fixes

New version v0.2.0 supports

  • added auto-reconnect
  • added sequentially selects
  • events (attach, detach, row, result, transaction, commit, rollback, error, etc.)
  • performance improvements
  • supports inserting/updating buffers and streams
  • reading blobs (sequentially)
  • pooling
  • database.detach() waits for last command
  • better unit-test
  • best of use with http://ww w.totaljs.com/

     




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Nice interview with the author of Sqitch



As you might now Ștefan Suciu created a Firebird port for sqitch https://github.com/theory/sqitch/blob/master/lib/sqitchtutorial-firebird.pod

Bellow is a interview with the author of Sqitch 


https://www.youtube.com/watch?v=TSfFzMdLHYg




__._,_.___
Posted by: mapopa <at> gmail.com


Community email addresses:
  Post message: Firebird-general <at> yahoogroups.com
  Subscribe:    Firebird-general-subscribe <at> yahoogroups.com
  Unsubscribe:  Firebird-general-unsubscribe <at> yahoogroups.com
  List owner:   Firebird-general-owner <at> yahoogroups.com

Shortcut URL to this page:
  http://www.yahoogroups.com/community/Firebird-general




__,_._,___
Picon

Zend server/php caching results

Hi All,


Zend  did a sales pitch to us this morning and we weren't the most impressed. Everyone we talk to who delivers solutions PHP+Mysql web applications seem to be obsessed with full page caches, op-code caching, and results caching. But they don't seem to mean the same thing as us when they say "application". Our history was migrating delphi apps to PHP around 2001 and we treat our app like an app that just happens to be using HTML+browser to render the UI. Firebird rocks for this and always has - the databases sit in OS disc cache for all practical purposes, queries are fast, and application logic is light.


Whilst I can see the benefit of full page caching to something like a shopping cart application, I simply can't imagine a single page in our app that a user would be happy to visit one second, and then the next we could be sure it hadn't changed - especially since they usually visit information repeatedly exactly when they are changing it, and old data that has become static through age is rarely accessed - so I've dismissed whole page caching. 


However, on every single page access there's a number of system options tables and caption tables that we hit that rarely change, and even if they do it's sort of OK if it takes seconds to propagate out the data to users, so I can see the potential for caching specific results. Most of our pages take about a second to load, and of that most of it is accessing data, and the "static" tables account for about 10ms. My gut feeling is that we simply shouldn't worry about caching results, but my colleagues aren't as convinced. Modern processors eat the load we throw at them, and 1s to a user is the same as 0.5s or 1.5s. Any longer begins to be noticeable, but doing magic to save 20ms seems like over optimisation.


I'm beginning to doubt myself, so here's the questions.


1. Are we the only people who think of PHP+Firebird as producing apps just like good old Delphi+Interbase?

2. Do people [on any stack] bother to cache query results as a matter of course?


3. If we've got servers with 30GB+ of database that are all OS-read-cached and PHP/Apache is happily sitting in < 1GB of memory, should we even be worried about op-code caching? Why is the PHP world obsessed with caching and load balancing?


4. I've been "happy" with php for 14 years, have I been mad and should we have been using Zend Server all along? [I respect your opinions more than any other forum even though it's nothing to do with firebird!]


Ta you lovely bunch,


Ian



__._,_.___
Posted by: wobbleian <at> yahoo.co.uk


Picon

ODBC documentation

   Hello, All.

   I wonder why ODBC documentation exists in CVS sources, but not in "Documentation" part 
of web-site?..

--

-- 
   WBR, SD.

------------------------------------

------------------------------------

Picon

NETProvider on github

Github model for contributions really works 


There are quite a few pull requests closed and merged for .NET Provider 


https://github.com/cincuranet/NETProvider/pulls?q=is%3Apr+is%3Aclosed


ps: posted on support by mistake 




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

Unhandled exception at 0x77EBB852

Dear All,
              Faction the exception like this,
Unhandled exception at 0x77EBB852 (ntdll.dll) in fsql.exe: 0xC0000005: Access violation writing location 0x00090F80

when i rung the application from vs2013 then this exception in not raised, other wise when i rung dirctly from bin then it show me the above highlighted exception.

Can anybody help me.


thanks

M Waqas Shahid



__._,_.___
Posted by: mwaqas_shahid <at> yahoo.com


Picon

Unhandled exception at 0x77EBB852

Dear All,
              Faction the exception like this,
Unhandled exception at 0x77EBB852 (ntdll.dll) in fsql.exe: 0xC0000005: Access violation writing location 0x00090F80

when i rung the application from vs2013 then this exception in not raised, other wise when i rung dirctly from bin then it show me the above highlighted exception.

Can anybody help me.


thanks

M Waqas Shahid

mwaqas_shahid <at> yahoo.com




__._,_.___
Posted by: mwaqas_shahid <at> yahoo.com


Picon

xkcd query

yet another xkcd query :)

http://xkcd.com/1409/




__._,_.___
Posted by: mapopa <at> gmail.com


Picon

We Have C++14

C++14 is announced
https://isocpp.org/blog/2014/08/we-have-cpp14

Summary of new features in C++14
http://en.wikipedia.org/wiki/C%2B%2B14#New_language_features

------------------------------------
Posted by: marius adrian popa <mapopa <at> gmail.com>
------------------------------------


Gmane