Remember, this was way back...

They were close, 100Mbit, but things didn't happen instantly.
Combination of OS, network card buffers, TCP/IP overhead, etc...
From memory, the connect was 0.1 secs, and each prepare was another 0.1.
Two queries on a page took 0.3 all up - 3(ish) pages/sec throughput, without
anything serious processing yet.

As you've indicated, things are very different now - time to revisit the old
methods...

Nige.

> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Wednesday, 17 November 2004 3:58 PM
> To: firebird-php@yahoogroups.com
> Subject: RE: [firebird-php] SPs Docs
>
>
>
> How far away from your DB server is your PHP page being
> executed? If it's
> close by e.g. the next box on a 100Mbit line, then it's
> instantaeous. I even
> have websites executing in Brisbane and DB servers in Sydney.
> They are only
> just noticeably slower.
> Alan
> -----Original Message-----
> From: Nigel Weeks [mailto:nweeks@...]
> Sent: Wednesday, November 17, 2004 3:48 PM
> To: firebird-php@yahoogroups.com
> Subject: RE: [firebird-php] SPs Docs
>
>
> Yeah, I'm just realising this...
>
> Back when I started with PHP and Firebird (0.9 ish),
> connects and prepares
> took ages.
> So the process of:
> prepare a query to retrieve a generator value
> run the query
> get the value
> prepare a query to insert a record with the new value
> run the query
> wasn't very appealing, as it took a while.
> They were the old days. The wire protocol has
> improved(compression on
> varchars), and things are much quicker now...
>
> The method of using a single call to a SP, and getting the
> ID back in one
> go
> was very attractive.
> I'll try the 'Recommended by the Elite' method of obtaining
> a value from a
> generator, then inserting.
>
> Thanks all!
>
> Nige.
>
> > -----Original Message-----
> > From: Alan McDonald [mailto:alan@...]
> > Sent: Wednesday, 17 November 2004 3:40 PM
> > To: firebird-php@yahoogroups.com
> > Subject: RE: [firebird-php] SPs Docs
> >
> >
> >
> > why is that so important a task Nigel? What's wrong with a 2
> > step procedure?
> > -----Original Message-----
> > From: Nigel Weeks [mailto:nweeks@...]
> > Sent: Wednesday, November 17, 2004 3:22 PM
> > To: firebird-php@yahoogroups.com
> > Subject: RE: [firebird-php] SPs Docs
> >
> >
> > Yes, normal usage is a single transaction, but it's not
> > always the case.
> >
> > The other problem is that the 'Firebird Elite' have frowned upon
> > the practice of using a 'Selectable Procedure' to do both:
> > A DML operation (Insert/Update/Delete), and
> > A return of a record set(via the suspend)
> >
> > Sure, it's possible, and I like using Procs in this way A
> > LOT!!, but I've
> > heard
> > it's just not the right way to do it...
> >
> > It's been recommended that the following should be adhered to:
> > 'Execute Procedures' should be used for DML ops
> (Ins/Upd/Del), and
> > 'Selectable Procs' should only be used for returning
> > datasets, fancy
> > queries, etc.
> > -> No data changes.
> >
> > I dunno yet, I can't think of a better way:
> > There's a six-pack of Cascade Beer for anyone who can solve it!
> >
> > Summary of Challenge: Insert a row, and return the new
> > generator-seeded ID
> > in ONE COMMAND/ONE QUERY from PHP, without using a
> selectable stored
> > procedure to do it...
> >
> > Nige.
> >
> >
> > Yahoo! Groups Sponsor
> >
> > Get unlimited calls to
> >
> > U.S./Canada
> >
> >
> >
> >
> > --------------------------------------------------------------
> > --------------
> > --
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/firebird-php/
> >
> > b.. To unsubscribe from this group, send an email to:
> > firebird-php-unsubscribe@yahoogroups.com
> >
> > c.. Your use of Yahoo! Groups is subject to the Yahoo!
> > Terms of Service.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > --------------------~-->
> > $9.95 domain names from Yahoo!. Register anything.
> > http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/PhFolB/TM
> > --------------------------------------------------------------
> > ------~->
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> Yahoo! Groups Sponsor
>
> Get unlimited calls to
>
> U.S./Canada
>
>
>
>
> --------------------------------------------------------------
> --------------
> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-php/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> $9.95 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/PhFolB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>