> - Im using OLAP, dont have alot of data today, but its growing, and is > very intensive query, everyone say that postgresql is better on complex > queries.
Generalizations like these do not make any sense because of lots and lots of variables involved: data set structure, size, query type, schema design, indexes, db engine in MySQL case, RAM, hardware, etc. Everything should bet tuned for particular task and only in that context we can talk about speed. Saying "X is slow and Y is fast" means nothing without context. And even in the case query Q is faster on dataset D on database X does not mean that database Y cannot be tuned to perform faster than that. <…> > Another question, about full text search, its better stick with the one > inside de database or something external like Sphinx!? Im worring about > speed and easy of use. My vote goes for Sphinx. MySQL full text search limits you to MyISAM tables and is only suitable if you need very basic search features and you dataset is not very big. PostgreSQL seems to have more advanced implementation but I doubt it can beat Sphinx in terms of features and speed. Regards, Rimantas -- http://rimantas.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
