Re: Loading 300000 lines into a database/regex database searching

[Charles Yeomans <yeomans at desuetude dot com>]

On Mar 30, 2005, at 9:50 PM, Asher Dunn wrote:

> What would be the best way to load a 300000 line text file into a 
> database? Each line would be one record with one field. With around 
> 300000 lines, so I'd rather not just loop through doing an individual 
> insert for each record.
> I'm looking for a way to load the data into the database all at once.
Which database?

> Also, is there any database that supports RegEx searching? Something 
> like:
> SELECT myField FROM myTable WHERE myField likeRegex('.*rb.*');
Valentina.

--------------
Charles Yeomans

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>