Mailing List Archive


Back to the month index Back to the list index
yuq-msql@wayx.com
Sun, 09 Nov 1997 16:18:19 +0800 

From: yuq-msql@wayx.com
Message-Id: <3.0.32.19971109161314.00696880@marcus>
Date: Sun, 09 Nov 1997 16:18:19 +0800
Subject: UGRENT! about delete

hi,all

It is me again.
This time ,my question is about delete.
Does the statement "Delete from <tablename> where <logic conditions>
"REALLY delete the contents physcially?I found the delete statement is
something LOGICALLY,it doesn't REALLY REMOVE those rows from physcial
files.How can I REALLY DELETE those rows ,so I can reduce the file size?

thanks
any advice please mail to yuq-msql@wayx.com
you are higly appreciately.
johnny.
From p.babu@giasmd01.vsnl.net.in Sun Nov 9 13:22:48 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id NAA01673
        for <msql-list@services.bunyip.com>; Sun, 9 Nov 1997 13:22:47 -0500 (EST)
Received: from md2.vsnl.net.in (md2.vsnl.net.in [202.54.6.20])
        by mocha.bunyip.com (8.8.5/8.8.5) with SMTP id NAA18966
        for <msql-list@Bunyip.Com>; Sun, 9 Nov 1997 13:22:18 -0500 (EST)
Received: by md2.vsnl.net.in; id AA16484; Sun, 9 Nov 1997 23:58:03 +0530
Message-Id: <3465F95F.24EA@giasmd01.vsnl.net.in>
Date: Sun, 09 Nov 1997 23:26:47 +0530
From: Parameshwar Babu <p.babu@giasmd01.vsnl.net.in>
Organization: Plans Proposals & Projects (PPP)
X-Mailer: Mozilla 3.01Gold (Win95; I)
Mime-Version: 1.0
To: msql-list@Bunyip.Com
Subject: Showing query results 10 at a time
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Suppose a msql query is called thru' phtml and the query returns about
30 records:

1. I want to show the results in 3 stages in steps of 10 records in a
page so that the visitor can browse the results by pressing "next 10
hit" button.
Is it possible to do it without re-executing the query each time?

2. For e.g, visit the page http://www.pppindia.com/trade/trade.html
where there are atleast 10-20 postings in a day with about 3000 hits per
day. If I convert this perl cgi into phtml-mSQL, will the mSQL be able
handle the burden? I hear people saying msql to be very vulnerable.

Thanks
Babu 

-- 
+------------------------------------------------------------------+
|Plans Proposals & Projects,    16, Periyar Street, Gandhi Nagar   |
|(Consultants)                  Saligramam,  Madras 600 093 India. |
| ___ ___ ___                   Phone :91-44-4831145,Telfax:4848328|
|| _ \ _ \ _ \                  mailto:p.babu@giasmd01.vsnl.net.in |
||  _/  _/  _/                  http://www.pppindia.com            |
||_| |_| |_|              Member: HTML Writers Guild               |
|                               : Microsoft SiteBuilder Network    |
+------------------------------------------------------------------+