Re: odbc vs mysql
| From: | John Lim | Date: | Wed, 03 Apr 2002 13:17:38 +0000 |
| Subject: | Re: odbc vs mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18158@lists.php.net to get a copy of this message | ||
Try odbc connection pooling. That should help.
"Maris Kalnins" <proximus@btv.lv> wrote in message
news:20020402172149.58164.qmail@pb1.pair.com...
> When connecting to database (Sybase) through ODBC it takes some time to
> establish odbc connection with:
>
> $cx=odbc_pconnect($G_dbname, $G_dblogin, $G_dbpassw);
>
> And only after that I am able to access data through SQL Selects
>
> The problem is that every time the script is finished this connection is
> automatically closed,
> how to keep it open after displaying a page - no idea ...
>
> How about using MySql in this situation?
> There will be no need to waste time connecting to ODBC every time,
> is it really so? could this be faster?
>
> is there any idea how to keep ODBC connections open after script is
> finished?
>
> Any other solutions?
>
> Thanks
>
> P.S. I tried to use Sybase funcitons.. but it says - that they're not
> defined or something like that..
>
>
>
>
>