View previous topic :: View next topic |
Author |
Message |
fabio -
Joined: 11 Feb 2005 Posts: 5 Location: Hungary
|
Posted: Sat Jul 16, 2005 10:41 am Post subject: PHP + MS Access connection too slow |
|
|
I use PHP as ISAPI extension and M$ Access (JET or ODBC) as database server. The connection to Access database engine is too slow, about 3-5 sec.
The same connection with the same config with Apache only 0.01 sec.
I use pconnect every time.
Could anybody help me? |
|
Back to top |
|
 |
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Sat Jul 16, 2005 1:36 pm Post subject: Re: PHP + MS Access connection too slow |
|
|
fabio,
Can you please post here a code sample so that we can test it? _________________ Support Team
Aprelium - http://www.aprelium.com |
|
Back to top |
|
 |
fabio -
Joined: 11 Feb 2005 Posts: 5 Location: Hungary
|
Posted: Sat Jul 16, 2005 3:47 pm Post subject: |
|
|
It is serious, the database is more than 20 MB! PHP ver 5.02
<?php
/***************************
* ADODB interfaces and functions
****************************/
//Adodb
require_once(ADODB_DIR."adodb.inc.php");
//******* create object and connect to database ****
$ADO_CON =&ADONewConnection('access');
$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=test.mdb;Uid=Admin;Pwd=;";
$t[0] =microtime();
$ADO_CON->PConnect($dsn);
$ADO_CON->debug = false;
$t[1] =microtime();
?>
thanx for help
Fabio |
|
Back to top |
|
 |
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Sun Jul 17, 2005 11:19 am Post subject: |
|
|
fabio,
We're going to test it and will send you our feedback. _________________ Support Team
Aprelium - http://www.aprelium.com |
|
Back to top |
|
 |
fabio -
Joined: 11 Feb 2005 Posts: 5 Location: Hungary
|
Posted: Sun Jul 17, 2005 3:30 pm Post subject: |
|
|
Thanx.
fabio |
|
Back to top |
|
 |
cmxflash -
Joined: 11 Dec 2004 Posts: 872
|
Posted: Tue Jul 19, 2005 7:34 am Post subject: |
|
|
"And that's why you should use MySQL" |
|
Back to top |
|
 |
|