Hey Everyone, If there are any Sybase ASE experts out there, I was wondering if there is a way to get Sybase to trace all the queries that it receives. I currently have a program running that usually begins displaying some strange behaviour after 7 hours from startup. I would like to find out what Sybase is doing at this time, so that...
a) I have 1000000 domain names b) Every domain has about 100000 sites c) each site has about 10000 visits daily / (5000 unique visits daily) d) As the owner of all those websites, I want to see, how many visitors on selected sites I had in a selected periods of time, for example: How many unique visitor were from 4th December 1987...
I don't really care if it's NoSQL or SQL based - as long as it uses int indexes (and stores them in RAM for fast searching) so I can find my data with simple queries based on criteria like user_id, lat, status, or other common int fields. The actual records can be stored on disk. My first guess would be SQLite - but it moves slowly when...
Other then Oracle, MySQL, and PostgreSQL, what is out there? Is there anything else used in a production environment? By production I mean it's used to support an active project or application and not an unstable system. I'm curious about other database systems (aside from NoSQL) that are applicable for use. Looking at the feature set ...
I am trying to work out the best database(s) considering the following requirements: The bulk of the data is "document" style, with specific common fields that will be indexed. There needs to be joining across these indexed fields. However, the data in the indexes is heavily hierarchical, i.e., graph. A specific example is the hierarch...