Suppose I have a table, made for my local network to store shared files, composed of this structure:
create table files (
id INT DEFAULT 0 NOT NULL AUTO_INCREMENT,
host VARCHAR(20),
dir VARCHAR(128),
file VARCHAR(200),
primary key(id));
Say that the local network of 50 computers are sharing something like 2.5 million files (and they are). I am making client software for the local users to search those files, but with 2.5 million rows, the database simply is not that fast fetching results---between 5-10 seconds per search. I'm using MySQL, but I was wondering if you all know if any of the other free database systems were faster. Suggestions?
Thanks,
Mike
create table files (
id INT DEFAULT 0 NOT NULL AUTO_INCREMENT,
host VARCHAR(20),
dir VARCHAR(128),
file VARCHAR(200),
primary key(id));
Say that the local network of 50 computers are sharing something like 2.5 million files (and they are). I am making client software for the local users to search those files, but with 2.5 million rows, the database simply is not that fast fetching results---between 5-10 seconds per search. I'm using MySQL, but I was wondering if you all know if any of the other free database systems were faster. Suggestions?
Thanks,
Mike