I am having speed issues when using large wildcard searches with one of my
applications.
It is using 'ActiveState Perl 5.6.1.635' on a Windows 2000 Server machine
and is connecting to the 'Microsoft SQL Server' for database storage.
I have connected using the ODBC driver and this is pretty much instant for
small searches. But larger searches are taking too long for the users (three
to fore minutes).
There are currently 1,196,473 unique assembly-component combination records
in the database; although this is set to grow to around two or three times
the size. This is currently split over 65,699 unique assembly records and
34,509 component records.
Two loops are used to search through two tables (via an linking table) for
all the assemble/component items that match a given criteria. My current
connection string is as follows: $dbh1 = DBI-> connect('DBI:ODBC:weeesql',
'WeeeViewer','weeeaccess'); I have the CGI, DBI and DBD-ODBC packages
loaded. Is there a better (faster) way of doing this?
_______________________________________________
Perl-Win32-Web mailing list
Perl-Win32-Web@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
