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.

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

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:

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 mysql

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 assume you're

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! From: Adel Ardalan [mailto

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 For

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? You'll learn

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 worked fine. Then I

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

2003-03-12 Thread Dan Rossi
] 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... I

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

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.

RE: paging of records.. any suggestions?

2002-07-17 Thread Cal Evans
= * * 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 can go