Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: DBI - Oracle 8 - Load many rows into a temp table w/o using SQL*Loader

by perrin (Chancellor)
on Jan 24, 2002 at 06:17 UTC ( [id://141112]=note: print w/replies, xml ) Need Help??


in reply to DBI - Oracle 8 - Load many rows into a temp table w/o using SQL*Loader

You may not be thrilled with this advice, but I think you're fighting a losing battle. You really need to have the sorting and the searching done by one engine or you will kill your performance moving large result sets around like this.

If swish-e is not able to sort, maybe you should consider using a different search engine or doing the word search in Oracle. Besides the Oracle full-text search, there are also good alternatives like DBIx::FullTextSearch. Or you could keep the sorting data in a dbm file and then use a Schwartzian Transform to sort the swish-e results by it.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://141112]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (2)
As of 2024-03-19 04:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found