Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #18417
| From | cb <cb@ppt.io.it> |
|---|---|
| Newsgroups | comp.lang.php |
| Subject | Re: Php/Mysql paginate results without resubmitting query |
| Date | 2020-11-20 08:36 +0100 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <rp7rl7$n54$1@gioia.aioe.org> (permalink) |
| References | <rp67bt$up2$1@gioia.aioe.org> <i1o7snFbhv4U1@mid.individual.net> |
Jerry & J.O. thanks for your attention !
>> How big is your database
400.000 rows
>> table definition:
MYSQL
"CREATE TABLE IF NOT EXISTS `Tablescore` ( \n"
+ " `Progr` INT AUTO_INCREMENT , \n"
+ " `Autore` varchar(512) NOT NULL, \n"
+ " `Lavoro` varchar(512) DEFAULT NULL, \n"
+ " `Link` varchar(512) DEFAULT NULL, \n"
+ " `NumFil` varchar(160) DEFAULT NULL, \n"
+ " `DateSubm` varchar(10) DEFAULT NULL, \n"
+ " `PlaceHolder` varchar(30) DEFAULT NULL,\n"
+ " `StrumentoGenerico` varchar(130) DEFAULT NULL,\n"
+ " `StrumentoSpecifico` varchar(130) DEFAULT NULL\n"
+ " , PRIMARY KEY (Progr)) \n"
+ "ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ";
>> query:
SELECT * from Tablescore ORDER BY Autore , Lavoro, StrumentoGenerico,
StrumentoSpecifico
>> max_execution_time:
N/A I'm running on an hosted system, so time_limit(anything) it's non
honored.
and that's reasonable !
On another (italian) newsgroup I got the suggestion to use a temp table.
I'll try it during the week-end.
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Php/Mysql paginate results without resubmitting query cb <cb@ppt.io.it> - 2020-11-19 17:43 +0100
Re: Php/Mysql paginate results without resubmitting query Jerry Stuckle <jstucklex@attglobal.net> - 2020-11-19 15:05 -0500
Re: Php/Mysql paginate results without resubmitting query cb <cb@ppt.io.it> - 2020-11-21 18:03 +0100
Re: Php/Mysql paginate results without resubmitting query "J.O. Aho" <user@example.net> - 2020-11-19 22:54 +0100
Re: Php/Mysql paginate results without resubmitting query cb <cb@ppt.io.it> - 2020-11-20 08:36 +0100
Re: Php/Mysql paginate results without resubmitting query cb <cb@ppt.io.it> - 2020-11-20 08:45 +0100
Re: Php/Mysql paginate results without resubmitting query cb <cb@ppt.io.it> - 2020-11-20 08:53 +0100
Re: Php/Mysql paginate results without resubmitting query "J.O. Aho" <user@example.net> - 2020-11-20 10:15 +0100
Re: Php/Mysql paginate results without resubmitting query cb <cb@ppt.io.it> - 2020-11-20 11:30 +0100
Re: Php/Mysql paginate results without resubmitting query Jerry Stuckle <jstucklex@attglobal.net> - 2020-11-20 11:05 -0500
Re: Php/Mysql paginate results without resubmitting query Arno Welzel <usenet@arnowelzel.de> - 2020-11-20 17:42 +0100
csiph-web