cr*********@yahoo.com wrote:
Hi everyone :)
Hi
I have made a form to get values and insert them to a database.
I have
1) A file conn.php that does the initial connections
2) The form file form.php
3) Action file action.php which gets values from form.php to do
insert/delete/update.
fine so far.
I am 'including' conn.php in action.php since I need to connect to make
an INSERT. However a simple INSERT takes a whole lot of time to
execute. Often runs upto more than 2-3 minutes.
Well, in situations like this, the first thing to check is: Does the
SQL-statement take so long, or is it something else?
So, instead of letting your action.php execute the SELECT/INSERT/UPDATE,
just print it before you execute it, then stop the script (exit).
Then copy the SQL-statement, and paste it into SQL+ or whatever that Oracle
interface is named these days.
If you can execute the query very fast directly, you know that you have to
look futher in the action.php script, or in the setup.
Chances are that your insert is very slow because the database is huge and
needs to do a lot of indexing and such.
If that is the case, contact the builder and ask for help.
If that is NOT the case, come back here, and show us more code. (Preferably
the relevant parts in action.php)
Regards,
Erwin Moller
PS: Maybe this is relevant, I am not sure because I am no Oracleguru. But in
Postgresql it makes a huge difference in speed if you connect directly with
UNIX-sockets instead of TCP/IP. Maybe Oracle has similar features?