harpal singh wrote: > hello all, > we have migrate from ms-sql to firebird2.0(super server) > for .net.but it is very slower than ms-sql. > plz help me........
What, specifically, is slower? I'd like to see: 1. The statement used to create the relevant tables & indexes (both from SQL Server and Firebird) 2. The statement that is running slower in Firebird than on SQL Server. Also, are you running both databases on equivalent hardware? Are you running on a multi-core/multi-CPU machine? Super server can only use a single core, so if you've got multiple CPUs, you're better off with classic server (at least, until Firebird 3.0 is released). Dean. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
