Re: [PHP-DB] trying to get pecl and phpize to build oci8

2008-11-17 Thread Thodoris
I have Fedoara 2.6.27.5-37.fc9.i686 that has perl: This is perl, v5.10.0 built for i386-linux-thread-multi I searched the entire system and found neither pecl or phpize Although this not a php question try: yum install php-devel -- Thodoris -- PHP Database Mailing List

[PHP-DB] Can MySql handle Large data?

2008-11-17 Thread Abah Joseph
I want to quickly ask if MySql can handle large data like 10 – 20 million rows in one database (e.g member table) The question came to my mind is, How did large website like Yahoo handle such data? Sure. Yahoo users may be more than 20 millions users or so. Users will have -permission table

Re: [PHP-DB] Can MySql handle Large data?

2008-11-17 Thread Yves Sucaet
Just my two cents, but I doubt if Yahoo uses the same implementation of MySQL as we do. They probably have a tweaked version of it that fits their needs better than the free public version. Bare in mind too that MySQL *is* a commercial company, even more so now they've been acquired by Sun.

Re: [PHP-DB] Can MySql handle Large data?

2008-11-17 Thread Fergus Gibson
On Mon, Nov 17, 2008 at 9:15 AM, Abah Joseph [EMAIL PROTECTED] wrote: The question came to my mind is, How did large website like Yahoo handle such data? Sure. Yahoo users may be more than 20 millions users or so. Very large data sets are often partitioned in some way so that a given lookup

RE: [PHP-DB] PHP4, mssql_* and SQL Server 2005

2008-11-17 Thread Weaver Hickerson
Follow up- We solved this by moving that hugemongous query into a stored procedure. Not the most elegant fix but until we get to PHP5 and native driver, etc it seems our only fix. -Original Message- From: Krister Karlström [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 05, 2008

[PHP-DB] oci_connect still not working...I added a debug statement

2008-11-17 Thread Fred Silsbee
errors are : OCI8 DEBUG: OCINlsEnvironmentVariableGet at (/home/oracle/oci8/oci8-1.3.4/oci8.c:1819) OCI8 DEBUG L1: Got NO cached connection at (/home/oracle/oci8/oci8-1.3.4/oci8.c:1864) OCI8 DEBUG: OCIEnvNlsCreate at (/home/oracle/oci8/oci8-1.3.4/oci8.c:2768) OCI8 DEBUG L1: create_spool: (0)

Re: [PHP-DB] oci_connect still not working...I added a debug statement

2008-11-17 Thread Chris
oci_internal_debug(1); // turn on tracing // Create a database connection // $conn = oci_connect(hr, hr, //dwlin165.us.oracle.com/lmkiiiGDNSID); That definitely won't work.. // $conn = oci_connect('hr', 'hr',$db); try oci_connect('hr', 'hr', '//localhost/xe'); I assume you unlocked