Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #18418
| From | cb <cb@ppt.io.it> |
|---|---|
| Newsgroups | comp.lang.php |
| Subject | Re: Php/Mysql paginate results without resubmitting query |
| Date | 2020-11-20 08:45 +0100 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <rp7s6v$toc$1@gioia.aioe.org> (permalink) |
| References | <rp67bt$up2$1@gioia.aioe.org> <i1o7snFbhv4U1@mid.individual.net> <rp7rl7$n54$1@gioia.aioe.org> |
addendum
>> indexes:
describe Tablescore;
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+--------------------+--------------+------+-----+---------+----------------+
| Progr | int(11) | NO | PRI | NULL |
auto_increment |
| Autore | varchar(512) | NO | MUL | NULL |
|
| Lavoro | varchar(512) | YES | MUL | NULL |
|
| Link | varchar(512) | YES | | NULL |
|
| NumFil | varchar(160) | YES | | NULL |
|
| DateSubm | varchar(10) | YES | | NULL |
|
| PlaceHolder | varchar(30) | YES | | NULL |
|
| StrumentoGenerico | varchar(130) | YES | MUL | NULL |
|
| StrumentoSpecifico | varchar(130) | YES | MUL | NULL |
|
+--------------------+--------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)
On 11/20/20 8:36 AM, cb wrote:
> 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