Re^3: In search of an efficient query abstractor

Are you doing the whole 8GB file at once? If your string starts with "a b c d", $query =~ s/\s{2,}/ /g; needs to copy 32GB of text. Just for the first 10 characters.

Comment on Re^3: In search of an efficient query abstractor Download Code

Replies are listed 'Best First'.
Re^4: In search of an efficient query abstractor by xaprb (Scribe) on Dec 07, 2008 at 20:57 UTC
No, it's done one entry at a time. Each entry is a header with some commented lines, followed by a query. There are special cases, but it generally looks like `# Time: 071015 21:43:52 # User@Host: root[root] @ localhost [] # Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 use test; select sleep(2) from n;` [download]	[reply] [d/l]


The stupid question is the question not asked
	PerlMonks