Of course, Ann, this is my test code for insert (same is for all dbms):

<?php

if (! $db) exit;

$dbconfig["sqlserver"] = "localhost";
$dbconfig["defaultdb"] = ($db == "ibase") ? "/tmp/pru.gdb" : "prueba";
$dbconfig["sqlusername"] = "nobody";
$dbconfig["sqlpassword"] = "nobody";

require("$db.db.inc");

$max = ($db == "pgsql-new") ? 1000 : 10000;

for ($i = 1; $i < $max; $i++)
{
$rs = dbquery("insert into nombres(id,name) values ($i,'record number
$i')");
}
echo "end.";

?>

Table : ID INTEGER NOT NULL, NOMBRE VARCHAR(100), PRIMARY KEY (ID)
System: Redhat Linux 6.2

It is very simple. As you can see, I am using a DB abstraction layer. (note:
Only first time dbquery is called, it opens a connection and calls to
ibase_query). Of course, using a layer is slower than without any, and using C
must be faster than using PHP4, but I made this test for my current
environment.

I don't think this was a bad result for Interbase in that configuration (only
64 Mb). Then, what I should say about PostgreSQL ?.

My only and real problem with Interbase is that without any reason some times
it turn slower and slower (I am talking about a 256M RAM Linux with 4 users)
running a Proxy (SQUID) and a web server (Apache).

I cannot explain why my log have so many INET bugs. Some people has reported
this thing before, but I haven't seen any answer. I hadn't be able to make a
conection between these bugs and those times when server seems to sleep but I
think that something is not working.


(sorry, excuse my very poor english)

Ann Harrison <harrison@...> dijo:

> I am very surprised at the insert times for InterBase.
> Can you tell me more about the code?
>
> Ann
>
>
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
>
>

--
Programmer
Integracion de Metodologias y Sistemas (Spain)
http://www.netims.com