|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: which solution is better for $count and 
cols
cols
From: Perrin Harkins (perrinelem.com)
Date: Fri Oct 24 2008 - 09:58:47 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Thu, Oct 23, 2008 at 10:31 PM, Fayland Lam <faylandgmail.com> wrote:
> B one SQLs with some operation
> SELECT col FROM table WHERE $where
> while $count is scalar cols and real cols is splice(cols, $start, $rows)
If you're talking about Perl/DBI, doing that normally loads the entire
result set into your program's memory. Using a LIMIT avoids that.
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]