• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ODBC Connection being extremely slow

#1
Exclamation 
Hi,

I'm looking to use ODBC in order to connect to an MSSQL database, however, just including the 'database' library in the autoload.php file is causing issues. Pages are therefore taking ages to load which is a serious problem, i'm having to wait 10-20 seconds.

Now, I am not running any queries at this time, it's clearly just the connection. Therefore I was wandering if their was a problem with my database connection settings. Let me show you them:

PHP Code:
$active_group 'default';
$query_builder TRUE;

$db['default'] = array(
    
'dsn'    => '',
    
'hostname' => 'Driver={SQL Server};Server=MATTHEW;Database=db1;',
    
'username' => 'root',
    
'password' => 'root',
    
'database' => 'db1',
    
'dbdriver' => 'odbc',
    
'dbprefix' => '',
    
'pconnect' => FALSE,
    
'db_debug' => TRUE,
    
'cache_on' => FALSE,
    
'cachedir' => '',
    
'char_set' => 'utf8',
    
'dbcollat' => 'utf8_general_ci',
    
'swap_pre' => '',
    
'encrypt' => FALSE,
    
'compress' => FALSE,
    
'stricton' => FALSE,
    
'failover' => array(),
    
'save_queries' => TRUE
); 

Is there a problem with what I'm doing? Is ODBC just slow with Codeigniter?

I've tried the same connection settings outside of Codeigniter and it runs smoothly but I would like my project to use Codeigniter so any help would be appreciated.
Reply

#2
If possible, you may want to use the SQLSRV driver instead. http://php.net/manual/en/intro.sqlsrv.php

However, when you say you used the same connection settings outside of CodeIgniter, does that mean you've setup a simple PHP script to run
Code:
$connection = odbc_connect('Driver={SQL Server};Server=MATTHEW;Database=db1;', 'root', 'root');
and check the result?
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.