Slightly off topic... choosing db server software
-
does anyone have any links or comments on how to choose a database server product? i have fairly large database in mysql on linux (os could cange) currently, but it is being bogged down, on some pretty serious hardware, and i think doing some optimized stored procedures,perhaps a full text index, etc would help... i have used a lot of the various databases, but haven't done much performance analysis... any thoughts? it does a lot of transactions, updates, inserts and selects... but the biggest slowdown is the relatively low percentage of searches.
-
does anyone have any links or comments on how to choose a database server product? i have fairly large database in mysql on linux (os could cange) currently, but it is being bogged down, on some pretty serious hardware, and i think doing some optimized stored procedures,perhaps a full text index, etc would help... i have used a lot of the various databases, but haven't done much performance analysis... any thoughts? it does a lot of transactions, updates, inserts and selects... but the biggest slowdown is the relatively low percentage of searches.
Could you give us an example of one slow search, and what indexes you have in place.