Re: memory issue: paging, disk activity, table size -> was: optimizing a select statement

2004-03-02 Thread Sasha Pachev
Karthik Viswanathan wrote: Thanks for the information. Before I try to further look into the query, I would like to know if there is some memory issue. Its strange since the speed for executing same query differs. Its a Mac G5 with just 1GB ram. I could see lot of pageouts in the top command. Th

memory issue: paging, disk activity, table size -> was: optimizing a select statement

2004-03-01 Thread Karthik Viswanathan
Thanks for the information. Before I try to further look into the query, I would like to know if there is some memory issue. Its strange since the speed for executing same query differs. Its a Mac G5 with just 1GB ram. I could see lot of pageouts in the top command. The activity monitor shows t

Re: Paging!

2004-01-29 Thread Fred van Engen
On Thu, Jan 29, 2004 at 11:19:27AM -0500, Mike Johnson wrote: > From: Dan Greene [mailto:[EMAIL PROTECTED] > > > another option is to set your pager option: > > > > mysql> pager more > > > > then re-run your query > > > Wow. You learn something new every day. > How about the 'help' command?

RE: Paging!

2004-01-29 Thread Mike Johnson
From: Dan Greene [mailto:[EMAIL PROTECTED] > another option is to set your pager option: > > mysql> pager more > > then re-run your query Wow. You learn something new every day. Thanks! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List F

RE: Paging!

2004-01-29 Thread Dan Greene
another option is to set your pager option: mysql> pager more then re-run your query > -Original Message- > From: Mike Johnson [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 11:01 AM > To: Adel Ardalan; [EMAIL PROTECTED] > Subject: RE: Paging! > &g

RE: Paging!

2004-01-29 Thread Mike Johnson
From: Mike Johnson > From: Adel Ardalan [mailto:[EMAIL PROTECTED] > > > When I select a rather large table to be shown, the rows are > > going very fast and I can't see the rows at the beginning. > > Also, I can't scroll up. How can I view the results page by > > page? > > > I can only assu

RE: Paging!

2004-01-29 Thread Mike Johnson
From: Adel Ardalan [mailto:[EMAIL PROTECTED] > When I select a rather large table to be shown, the rows are > going very fast and I can't see the rows at the beginning. > Also, I can't scroll up. How can I view the results page by > page? I can only assume you're talking about the native mysq

Paging!

2004-01-29 Thread Adel Ardalan
When I select a rather large table to be shown, the rows are going very fast and I can't see the rows at the beginning. Also, I can't scroll up. How can I view the results page by page? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

RE: Recordset paging with php on mySql database ... works on first page but ...

2003-03-12 Thread Dan Rossi
ECTED] Sent: Thursday, March 13, 2003 5:20 AM To: [EMAIL PROTECTED] Subject: Recordset paging with php on mySql database ... works on first page but ... I had asked the group previously about limiting the results shown on my website to a certain number and then navigating to the next group etc.

Recordset paging with php on mySql database ... works on first page but ...

2003-03-12 Thread Stitchin'
I had asked the group previously about limiting the results shown on my website to a certain number and then navigating to the next group etc... I found a great article by Joe O'Donnell called "Building A Dynamic MySql Paging Class with PHP" ... I created his example and it worke

RE: paging of records.. any suggestions?

2002-07-17 Thread Cal Evans
H, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: forum mail [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:30 AM To: [EMAIL PROTECTED] Subject: paging of records.. any suggestions? Hi list, I would like to get any suggestion on how i c

Re: paging of records.. any suggestions?

2002-07-17 Thread Shashank Tripathi
Hi, Not sure which language you are using, but I hope this will give you some ideas: http://www.phpbuilder.com/columns/rod20001214.php3 Hope this is useful, Shashank -- sql, query, select etc. all the jazz that will make this message go through to the list. --

paging of records.. any suggestions?

2002-07-17 Thread forum mail
Hi list, I would like to get any suggestion on how i can go about my problem the most efficient way. I have a program that reads the log file and displays it for the user. At the moment, it retrieves all the data in mysql database. I would want to add paging capabilities to it. I am