Hi,
I'm very new to MySQL and tries to execute some applications with it...
I'm having problems which are certainly do to a misunderstanding of how
MySQL works...
I want to access to MySQL with any application where I want to show only the
20th records of the table or of the result of a query (which in fact seems
very standart). Then I'm waiting for the end-user to ask for the next 20
records as I don't need to get all the records at the same time.
What surprises me in MySQL is that it seems to give me all the result set
before my first fetch.
So even if I work in a Client/Server configuration, it will send all the
records (perhaps some 10000) even if I need only 20.
I saw that the #LIMIT directive allowed me to get only a few records at a
time. But the problem is that if I want to get then the next records, it
will execute the Query again and if this query needs to create temporary
files, it will build this temporary file again...
I just wanted to know if my assertions are rigth and what are the common way
to solve this type of problems ?
Thanks
Patrick
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
