[PHP-DB] Help : search for a word and its number
Hi, I need a favour from you guys 'n girls : If I have records like this ID Content 1 "John have a red book, and a yellow book. He give a yellow book to Tina". 2 "Luke doesn't have any book at all, he always borrow it from John". 3 "John like swimming". Can I search this records (table) for a word "book" and also number of "book" occurences at every record? From table above, the result would be ID Number 13 21 I use Oracle 8.1.7. Thanks, Adi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Magic quotes sybase
Hi, can I enabled or disabled magic_quotes_sybase at runtime?
Or is there any workaround so character (') doesn't treated as (''),
because of magic_quotes_sybase ?
Thanks,
--
Adi Wibowo -- http://dewey.petra.ac.id
* Work matter: [EMAIL PROTECTED]
* Private matter : [EMAIL PROTECTED]
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP vs. 2 database softwares
On Mon, 1 Oct 2001, Scott Fletcher wrote: > Date: Mon, 1 Oct 2001 12:11:12 -0400 > From: Scott Fletcher <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: [PHP-DB] PHP vs. 2 database softwares > > Hi! > > I found that PHP can be compiled and work with only one database > software. You won't be able to have PHP to work with 2 seperate database > softwares. (You can compile it but it will work only with one databse > software, not both, no matter what). I checked the php "./configure" file > and found that it is not design to include 2 seperate databases when you > want it to. I used ./configure in order to access Oracle and MySQL and it worked. Adi Wibowo -- http://dewey.petra.ac.id * Work matter: [EMAIL PROTECTED] * Private matter : [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: Fwd: Re: [PHP-DB] OCIFetch performance problem with more rows
On Wed, 23 May 2001, Thies C. Arntzen wrote: > > > > I have performance problem with OCIFetch (and OCIFetchInto, too) > > > > when query return more rows.Same query from sqlplus is more fastest (more > > > > rows is worse then less rows) > > Indexes aren't problem.I use php and sqlplus with same tables. > > Sqlplus is faster. Of course SQLPlus execution *seems* tob faster. Once again ... seems ... This is caused by different optimation approach executed by Oracle. There are two kind of optimation : - Rule based optimation : faster first row - Cost based optimation : faster all row Rule Based Optimation will give you faster FIRST ROW display. First row will be displayed as fast as it can eventhough all necesarry process/steps are not done yet. This is good for access via tools like SQLPlus, where operator doesn't want to wait for a long time just to see the first row. But this doesn't suit for some kind of operation like OLTP (Online Transaction Processing like accessing oracle using PHP. This is where cost based optimation take action. CBO gives best througput using the least amount of resourcess necessary to process all rows accessed by sql statement. It means faster time for returning ALL rows compared with RBO. So you see that SQLPlus give you faster result .. BUT .. only for the first row. So it seems to be faster. But it doesn't. Important : Eventhough oracle will use CBO as a default, but it need some conditions to be met. Oracle Data dictionary need to have statistics about all schema object on your database. We should collect statistics by using DBMS_STATS package, or ANALIZYE statement. Otherwise oracle will use RBO which is slower to return data to our PHP. It will be better if we use document from oracle site : "Oracle 8i : Designing and Tuning for Performance". Adi Wibowo --- * Work matter: [EMAIL PROTECTED] * Private matter : [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] How to migrate Oracle 4.01 database?
On Fri, 9 Mar 2001, [gb2312] ³Âΰƽ wrote: > Hi, > I have a database based on Oracle 4.01. Now I want to migrate it to Oracle 8i. > Does anyone have reference to me? Hi, I (we) have a database based on Oracle 6. And we want to migrate to Oracle 8i. After some consultations with Oracle Support in my country they suggest that we should upgrade to Oracle 7 and then Oracle 8. Why? There is no tool to upgrade a database from version below 7 and differences between the two (6 vs 8) is so big, so there is no safe way than clean install Oracle 8i server onto another server, create a database with exact scheme, and retrieve every row of data from an old database and save it (insert) into a new database. It work for us now. And we glad seeing the result is so good. Adi Wibowo --- * Work matter: [EMAIL PROTECTED] * Private matter : [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
