Assuming both scenarios only had one connection open for all the
statements,
you probably will see a savings. You will need to benchmark your
situation.
You will need MySQL 4.1 or greater and your ODBC driver will need to
support
this version as well.
Ed
-Original Message-
From: Paul McN
You can create another frame that's "invisible" by having a zero height or
width. This can be your page that does all the queries and refreshes.
You can then use the javascript command document.write() to update the other
frames without having to hit the server again. Or, retrieve the data in the
You're running 3 entirely independent scripts, so they can't share a connection.
You may save an infinitessimal amount of time by using mysql_pconnect() instead of
mysql_connect(), which will give each process/thread a permanent database connection,
so it doesn't have to connect every time.
Ad
Hi.
On Tue, Oct 02, 2001 at 03:14:33PM -0500, [EMAIL PROTECTED] wrote:
> Hello All,
>
> I have several queries that generate various financial reports, by date ranges.
> I've been trying to figure out a way to combine all these queries into one query
> , if it's at all possible or if it's practi
[EMAIL PROTECTED] writes:
> I've been trying to figure out a way to combine all these queries into one query
> , if it's at all possible or if it's practical to combine them into one large
> query. The single query I tried doesn't produce the proper results.
[SNIP]
I'm not surprised, seeing how
