Foros

Malete: quering a lot of records

Autor	Mensaje
Escrito en: 07. 07. 2004 [14:44]
ncesar@lunix.com.ar Nicolas D. Cesar Autor del tema registrado desde: 31.12.1969 Entradas: 0	=2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 People: I'm using malete 0.9.9c as a back end for a PHP aplication. I don't know i= f=20 this is the correct list to post this message, if not please tell me. I have around 30 records in the result of a query but just displays 20, I k= now =2D -------------Limits.txt------------------- * limits Several limits apply to query and especially search evaluation. Some are currently hardcoded, but may become configuration options in future releases. (..) =2D - the number of open queries is limited by session option q (defa= ult=20 20). =2D ---------------------------------------- how can get the next 10 records? when I query, server says: =2D ----------------------------------------- oStruct 'cepal.Q %publicacion?' facMain 'cepal' oDBo 'Q %publicacion?' parsing '%publicacion?' as search c0 % "publicacion"/0 (..) got 30 parsing '' as filter c0 null successfully parsed 0 bytes cost 0 20 of 30 results off 0 got 0 in recv =2D -------------------------------------- =2D --=20 Nicol=E1s D. C=E9sar <ncesar@lunix.com.ar> Lunix [ Soluciones en GNU/Linux ] http://www.lunix.com.ar BOFH excuse #197: I'm sorry a pentium won't do, you need an SGI to connect with us. =2D----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA7FKqPMmt0zYG8+YRAro5AKC1Ys2Z+xV2by8DzKs8oQitsrbM1ACfTvxI wrKxSOxoqhG5jI9hw7TdrMQ=3D =3DFzuC =2D----END PGP SIGNATURE----- ------------------------------------------ Posted to Phorum via PhorumMail
	Perfil
Escrito en: 20. 07. 2004 [11:47]
paul@malete.org Klaus Ripke registrado desde: 31.12.1969 Entradas: 0	Hola Nicolas On Wednesday 07 July 2004 21:44, Nicolas D. Cesar wrote: > - the number of open queries is limited by session option q (defa= ult > 20). This is the number of different queries for which you can fetch results using #n. The number s of results per query is limited to 10000 (see note to Luis), and the number of results transmitted per read is yet another parameter r, which, like q, defaults to 20, and like all the others will be configurable once configuration is workin= g. > how can get the next 10 records? see the php/demo.php: <h3>query reading mfns</h3> <?php $mfns =3D $db->query('plant + water + devel$', false); do { echo "got ",count($mfns), " mfns: ", join(',',$mfns),"</br>\n"; } while ($mfns =3D $db->query(null,false)); ?> I get output: <h3>query reading mfns</h3> got 20 mfns: 2,3,4,5,6,8,10,11,12,13,14,16,21,22,24,25,27,43,52,57</br> got 18 mfns:=20 86,87,100,111,114,118,124,127,128,130,131,132,133,134,141,147,149,150</br= > since the $db->query(null,false)); sends a Q with no parameters, which fetches more results. As a plain telnet session: $ telnet localhost 2042 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. test.Q a$ # 78 4 0 0 2 0 3 0 4 0 5 0 6 0 17 0 22 0 24 0 29 0 30 0 31 0 34 0 37 0 39 0 41 0 43 0 46 0 47 0 50 0 55 test.Q # 58 4 0 0 57 0 58 0 59 0 60 0 61 0 62 0 65 0 67 0 69 0 70 0 71 0 73 0 74 0 75 0 79 0 80 0 82 0 84 0 85 0 86 (actually with TABs instead of the spaces). saludos Klaus ------------------------------------------ Posted to Phorum via PhorumMail
	Perfil