no one can help me outta here ?
On Mon, 21 Mar 2005 01:58:10 +0100, Zouari Fourat [EMAIL PROTECTED] wrote:
Hello,
i made my own paginating class, it permit me to paginate over selected
data and let me do good presentation (page 1, page 2 ...)
i use adodb for db related functions, my
[EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Re: paginating : optimising queries
Date: Tue, 22 Mar 2005 17:02:57 +0100
no one can help me outta here ?
On Mon, 21 Mar 2005 01:58:10 +0100, Zouari Fourat [EMAIL PROTECTED] wrote:
Hello,
i made my own paginating class, it permit me
to a page window calculated in
step 3.
Hope this helps.
- Aman Patel, Sys Admin / Database / Web Developer, International
Outreach x4076
-Original Message-
From: Zouari Fourat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 10:03 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Re
Subject: [PHP-DB] Re: paginating : optimising
queries
no one can help me outta here ?
On Mon, 21 Mar 2005 01:58:10 +0100, Zouari Fourat
[EMAIL PROTECTED] wrote:
Hello,
i made my own paginating class, it permit me to
paginate
over selected
data and let me do good
Hatem wrote:
Fetching 10 rows is much faster than 1000 ! Fourat
your code is optimized just keep it as it :) just keep
your code away from adodb, pear db, and such
abstraction if you want speed ! you don't need to talk
about optimisation with 2 queries.
Regards,
Hatem
Depends on the DB, in many
Martin Norland wrote:
Hatem wrote:
Fetching 10 rows is much faster than 1000 ! Fourat
your code is optimized just keep it as it :) just keep
your code away from adodb, pear db, and such
abstraction if you want speed ! you don't need to talk
about optimisation with 2 queries.
Regards,
Hatem
Depends
Lester Caine wrote:
[snip]
Don't know what you are using ;)
Transferring 1000 records is always going to take time, when you only
need 10 to be displayed.
[snip]
I wasn't referring to transferring the record, only running the query.
[snip]
Run the query without the limit, this gives you the count
On a side note, who's sick of seeing the word optimizing misspelled in
the title? :)
Ah, the things we do to keep a thread clean.
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
On a side note, who's sick of seeing the word optimizing misspelled in
the title? :)
Ah, the things we do to keep a thread clean.
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Well, of course, _optimise_ is the British spelling of _optimize_ .
Afterall, this
[EMAIL PROTECTED] wrote:
On a side note, who's sick of seeing the word optimizing misspelled in
the title? :)
Ah, the things we do to keep a thread clean.
[snip]
Well, of course, _optimise_ is the British spelling of _optimize_ .
Afterall, this __is__ an international list ;-
David
My
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 2:36 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Re: paginating : optimising queries
[EMAIL PROTECTED] wrote:
On a side note, who's sick of seeing the word optimizing misspelled in
the title? :)
Ah, the things we do to keep
Hutchins, Richard wrote:
nonesense??
Sorry, couldn't resist, Martin. ;)
This isn't a spelling bee anyway. I don't think it actually matters to
anybody. I'll take solid programming advice with a few spelling errors over
a shot in the dark with perfect spelling any day.
Elbonian spelling.
[EMAIL PROTECTED] wrote:
On a side note, who's sick of seeing the word optimizing misspelled
in
the title? :)
Ah, the things we do to keep a thread clean.
[snip]
Well, of course, _optimise_ is the British spelling of _optimize_ .
Afterall, this __is__ an international list ;-
[EMAIL PROTECTED] wrote:
[snip]
My apologies to all, 'dict' tricked me - it has 'optimize', 'optimise',
'optimizing', but not 'optimising' - and I foolishly only checked the
-ing conjugated tense instead of the root! (I do try a cursory check
before posting such nonesense, honest!)
Now back to
My apologies to all, i've mispelled that word, because in frensh we
say optimisation/optimiser ... there's no snoop dog's in zat :)
as about the subject, i think am no going to change my method and i'll
use ADOdb for some reasons (performance alse) :
* my application should be db
15 matches
Mail list logo