Whats the best/fastest way of setting up this database? Mysql regexp is far to slow - any ideas anyone? Needs to match B3N for BEN etc etc
2007-02-21 07:23:54 · 2 answers · asked by Neil T 1 in Computers & Internet ➔ Programming & Design
As a suggestion, why not break up the single table into 36 seperate tables. One table for each possible letter or number of the first character of a plate number. So BEN 123 will use the B table while CEN 123 will use the C table.
2007-02-21 09:37:37 · answer #1 · answered by MarkG 7 · 0⤊ 0⤋
It's hard to answer without understanding the full requirements of your application.
Is it possible to anticipate regex patterns and pre-run your some of your results so that they are readily accessible? It's unclear whether this problem could be solved like you would a data warehousing problem.
2007-02-21 16:04:16 · answer #2 · answered by Skeptic 7 · 0⤊ 0⤋