[PHP-DB] Turtle slow bind variables are 6 times slower in Oracle?

Hello, I recently benchmarked using bind variables for inserts versus sending simple sql over to oracle 8.1.7. Surprisingly, sending simple sql was nearly 6 times faster. My database is using cursor_sharing=force. Can anyone else verify this? >>> Not using bind variables (MySQL and Oracle),

[PHP-DB] Re: Is there a better way to do this?

Leif K-Brooks <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I operate a small game site for kids. On this site, the players can, among > other things, buy virtual items. I have each item stored in a table called > "items" in a mysql database. The type is

[PHP-DB] Joining three tables

SQL QUERY question I have three tables: students has student_id and student_name parents has parent_id and parent_name parentlog has student_id and parent_id I want to search the parentlog WHERE student_id = some_id GROUP BY parent_id (This will bring back two rows when there are two parents)

RE: [PHP-DB] Is there a better way to do this?

Hi, Why don't you add another column to your "items" table for the item name..Then you can just fetch each row to an array and call it by $row["item_name"] ? For better explanation: Say you added a column to hold item names in your items table called item_name ... I have no idea how you query i

[PHP-DB] Is there a better way to do this?

I operate a small game site for kids. On this site, the players can, among other things, buy virtual items. I have each item stored in a table called "items" in a mysql database. The type is one column in that table, but it is a number, not a name. When I want to display items with the item n

Re: [PHP-DB] how to start and bring down mysql.server on OSX

on 3/15/02 9:51 AM, andy at [EMAIL PROTECTED] appended the following bits to my mbox: > Anyhow I would like to start it automaticly at boot time. I tryed to start > the server by typing mysql.server start, but I get an command not found. i > gueess I am in the right dir. Check out Marc Liyange's

Re: [PHP-DB] Date Returns

On Saturday 16 March 2002 00:14, Ryan Marrs wrote: > Does anyone know if the date function returns false if it cannot convert > the specified date/time to the format? If not, does anyone have a rule set > they use to verify the date is a valid convertible date? I need to update > a row in MSSQL,

Re: [PHP-DB] how to start and bring down mysql.server on OSX

Twas 3/15/02 9:51 AM, when "andy" <[EMAIL PROTECTED]> said: > Hi there, > > I am running mysql 3.23.38 on os x. Till now I did start the server by unix > command safe_mysqld. This worked, but did always freeze the shell and I did > have to open a new one. Bringing down the server worked only by

[PHP-DB] RE: [PHP-WIN] Stange 'page-loading' effect

You probably have an error in your code, difficult to help without at least a snippet of it. A+ Alain -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 4:14 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-WIN] Stange 'page-loading'

RE: [PHP-DB] Content Management - best way to store data

Hi olinux, > Is it best to store article data in XML - if so how? if it could be a webapplicationserver too have a look on zope http://www.zope.org The Roxen-CMS is based on xml but I have heared from friends that they wasn't able to build an intranet with it. It's totaly different to html and

[PHP-DB] Date Returns

Does anyone know if the date function returns false if it cannot convert the specified date/time to the format? If not, does anyone have a rule set they use to verify the date is a valid convertible date? I need to update a row in MSSQL, and it will fail if the date is incorrect. I've validated

[PHP-DB] Content Management - best way to store data

I'm doing a lot of research on content management systems and wanted to get input on how to store article data. Is it best to store article data in XML - if so how? Thanks much, olinux __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage

[PHP-DB] how to start and bring down mysql.server on OSX

Hi there, I am running mysql 3.23.38 on os x. Till now I did start the server by unix command safe_mysqld. This worked, but did always freeze the shell and I did have to open a new one. Bringing down the server worked only by rebooting. mysqladmin shutdown did also freeze the shell and nothing ha

[PHP-DB] Stange 'page-loading' effect

Hi all, I have a part of my development site where the user hits a button, sending a stream of values to a response page. However, on testing, the response page comes up with 'server not found' but when I refresh that error page, it loads the correct page but without any of the transferred value