Quote:
Originally posted by CompareStore
How many servers have you got to supply the feeds?
I'm sure you've thought of this but if you are allowing things like SQL "like" statements you could find the database and servers under quite heavy load so make sure you have over estimated and have enough servers with load balancing set up to handle all the requests.
I can't wait to get hold of all that lovely data!
|
SQL Like queries is basically a way of querying data in a way you would do using SQL but they aren't real SQL queries. For example lets say you wanted all products which were between £10 and £50, plus the name contained the word football. The query you would use is
Quote:
|
Price >= 10 and Price <= 50 and ProductName =~ football
|
So its like SQL, but it isn't, although over time we will extend what you can do with these queries. As for server load, we will keep a close eye on load and before its needed add another server to cope with the load and so on.