Re: Multi-Search

GS-Base

www.citadel5.com

GS-Calc
GS-Calc is a spreadsheet that lets you track your expenses and incomes, quickly edit huge text files and databases as well as perform the most demanding statistical calculations and data analysis.
12 million rows x 4,096 columns.
A unique feature of organizing worksheets in a tree form.
Efficient memory usage to quickly load and save the largest files.
Fast pivot tables, optimization and other advanced statistical functions.
Using up to 16 processor cores during calculations.
A unique feature of working in up to 100 synchronized panes to boost your productivity.
GS-Calc can be installed on any portable device and used without performing any registry

GS-Base
GS-Base is a database that lets you organize your photo albums, mp3's, CDs, icon collections and your personal or business contacts. You can also quickly and easily analyze very large data sets using fast pivot tables with up to 12 million records and over 2,000 columns.
Any number of tables in one file; 12 mln records in one table; 2,047 fields in one record.
Versatile record filtering methods, searching for duplicates, full-text searches and one-click statistical breakdown analysis.
Printing serial forms, letters/reports and any type of mailing labels.
Sending serial personalized e-mail messages with customized attachments.
Creating and editing text, dBase, Clipper and FoxPro files.
Around 300 built-in calculation function used for calculated fields and data validation.
Multiple panes displaying synchronized tables, forms, memo fields and pivot tables.
GS-Base can be installed on any portable device and used without performing any registry modifications.

Edited 4 time(s). Last edit at 2014-10-05 14:07 by maki.

I think you should ask Microsoft to solve your problem instead of bothering us with tons of useless messages.
Or you can ask your mom, your teacher, who you want but if you don't want to understand that you need to learn, listen and try by yourself to find your solution you will never find somebody you solves your problems for you; unless you pay a lot of money.
Please stop filling this forum with useless messages and grow up. or at least try to grow up.

I tested speed now.
Simple cycle case sensitive search for substring in string 1 000 000 times takes about 2s.
For 2 000 000 000 more than 1 hour. For such long run is necessary to show some progress, make application react for user + read strings from list. In the final it means about 3-4 hours of program run.

For case insensitive I see one possibility only - convert both files e.g. to uppercase before search.
Convert strings inside cycle will cause several thousand times more conversion and it will significantly slow down searching.

maki:

GS-Base

If GS-Base allows you to write your own queries, try it. It's fasted way for you now how to solve your problem.

massimobalestra:

Maki says "shut up"

pspad - uppercase letter - no problem ! OK!

Edited 2 time(s). Last edit at 2014-10-05 15:14 by maki.

99% DONE...

Now I have to change all the names of the regex

Remove
1.....5000#namefile.jpg

703#qhaQ0Xq_5D8\.jpg

(\d+)#$
Replace $1

not work

wrong regex???

100% done...

Now wait for the result .. Only 1% progress

25,000,000 lines = many hours :D

I go to sleep and in the morning can be 100%

Edited 1 time(s). Last edit at 2014-10-05 19:05 by maki.