On Mon, Apr 11, 2011 at 9:29 AM, Office Geotek <[email protected]> wrote: > hello > > i want to ask is there query cache in firebird 1.5 ?
If what you're asking about is a query cache like the one in MySQL, then no, not in 1.5, 2.0, 2.1, 2.5, or planned for 3.0 to the best of my knowledge. The page caches will tend to keep frequently referenced index and data page in memory - as will the system file cache - and the use of prepared statements avoids the overhead of compilation and optimization. And, as Vlad suggested, stored procedures also reduce the cost of frequently used queries. Good luck, Ann ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
