PHP + MS Access connection too slow

 
Post new topic   Reply to topic    Aprelium Forum Index -> PHP
View previous topic :: View next topic  
Author Message
fabio
-


Joined: 11 Feb 2005
Posts: 5
Location: Hungary

PostPosted: Sat Jul 16, 2005 10:41 am    Post subject: PHP + MS Access connection too slow Reply with quote

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 View user's profile Send private message Visit poster's website
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Sat Jul 16, 2005 1:36 pm    Post subject: Re: PHP + MS Access connection too slow Reply with quote

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 View user's profile Send private message Send e-mail
fabio
-


Joined: 11 Feb 2005
Posts: 5
Location: Hungary

PostPosted: Sat Jul 16, 2005 3:47 pm    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Sun Jul 17, 2005 11:19 am    Post subject: Reply with quote

fabio,

We're going to test it and will send you our feedback.
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
fabio
-


Joined: 11 Feb 2005
Posts: 5
Location: Hungary

PostPosted: Sun Jul 17, 2005 3:30 pm    Post subject: Reply with quote

Thanx.

fabio
Back to top View user's profile Send private message Visit poster's website
cmxflash
-


Joined: 11 Dec 2004
Posts: 872

PostPosted: Tue Jul 19, 2005 7:34 am    Post subject: Reply with quote

"And that's why you should use MySQL"
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> PHP All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group