[mv] MV4 on Linux and Interbase on WIN NT - VERY slow queries

["Stefan Schaffner [ASS mv-d]" <mv-user@ass-software.de>]

******    message to minivend-users from "Stefan Schaffner [ASS mv-d]" <mv-user@ass-software.de>     ******

Hello list,

I have a problem with SQL queries. First my configuration:

	Linux 6.1
	- MV 4.04
	- IBPerl 0.8 beta
	- DBI für Interbase 1.13
	- Perl 5.004

	Windows NT 4.0
	- Interbase 5.6

The database is located on a NT Server. There're round about 15000 records
with 60 columns in the main table. I can access the Interbase database under
Linux and Perl (DBI function). Now I want to do a simple SQL query with
MiniVend showing the results on sqltest/results2:

    <form action=[area search] method=post>
        <input type=hidden name=mv_search_page value=sqltest/results2>
        <input type=hidden name=mv_searchtype value=sql>
        <INPUT TYPE=hidden NAME=mv_sql_query
          VALUE="SELECT ID,NAME,PLZ,ORT FROM hotels where (PLZ = 64283)">
        <input type=submit value=Search>
    </form>

This works fine at all and is fast enough! I can display the records using
[item-param NAME] at the result page. But know I want to enable a text field
to enter a search value. So I added the following line into FORM-code:

        <input type=text name=mv_searchspec>

After clicking Search button - with or without using the '?' in the query -
the Linux server slows sown and take up to 5 min to complete the query and
display the result page (with 5 records). I've the same problem using the
internal MV search routines! I don't understand, why a simple mv_searchspec
crashed the server in that way!

Best,
  Stefan


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list