oData

Technical Article

RE: Need help implementing FILO ordering on fixed size database

  • Reply

For our 24x7 website we have a number of tables that record session information, including each page a user visited. this table averages around 4-5mil records. To keep the size manageable, we run a job every hour which moves records older than 60 days into an archive database. We used to run it every day […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-06-22

Technical Article

RE: How do I decide, why index here and not there?

  • Reply

Buell, please don't take my post the wrong way; I'm only trying to help. I believe that if you have numerous queries like the one you posted, you are heading for disaster. -- To begin with, have you denormalized the data set on purpose? The AGENT_NAME, QUEUE_ID, and SITE_ID are fields which should be stored […]

2003-07-22

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers