Things you always wanted to know the answer to [Vol. 3]
Discussion
BlackVanDyke said:
How can the entire neighbourhood know about a nasty drug dealer and yet they still be plying their trade and enjoying their freedom?
cynical says they are being watched for bigger fishPH cycnical says because the police are out catching innocent motorists for... things
Has anyone in the neighbourhood tried calling the police and.. you know, telling them he's a drug dealer?
They call it "intelligence led policing"
Databases store data, then an application comes along and talks to the database, gets some data from it then does stuff with the data from the database, in memory.
The data in the database has limits defined not for the database but for when it's being used outside the database.
Thanks for the racing tv suggestions
This is the one area where Netflix can't match old school TV.. not sure if Motors has a catchup service. I can never plan to be in front of the TV at a specific time
They call it "intelligence led policing"
fomb said:
This makes me wonder if you know how to computer. It's a database, there's no address space in a database, there's a primary key. I would assume the limit is imposed for performance reasons. Maybe the caching tier is dramatically faster this way, maybe it's to do with aggregates such as post counts for a thread, but it's definitely naff all to do with memory address space.
The data in the database has to be loaded in to memory, at that point it stops being a database and just becomes data in memory, with a pointer and a variable type and a length.Databases store data, then an application comes along and talks to the database, gets some data from it then does stuff with the data from the database, in memory.
The data in the database has limits defined not for the database but for when it's being used outside the database.
Thanks for the racing tv suggestions
This is the one area where Netflix can't match old school TV.. not sure if Motors has a catchup service. I can never plan to be in front of the TV at a specific time
Edited by scarble on Tuesday 24th February 09:14
scarble said:
The data in the database has to be loaded in to memory, at that point it stops being a database and just becomes data in memory, with a pointer and a variable type and a length.
Databases store data, then an application comes along and talks to the database, gets some data from it then does stuff with the data from the database, in memory.
The data in the database has limits defined not for the database but for when it's being used outside the database.
Sure - but you don't load the entire DB into memory - just the bits you need, so the size of PH is irrelevant. Do you think Google loads the internet into RAM when you query that?Databases store data, then an application comes along and talks to the database, gets some data from it then does stuff with the data from the database, in memory.
The data in the database has limits defined not for the database but for when it's being used outside the database.
Again - you don't load the whole thread, you load the 20 or so posts on the page, and get the DB to run a count of the number of posts in the thread for the pagination.
In the 20 years I've been building web apps I've not once had to consider memory address limits. I am pretty sure the 500 page limit is for performance reasons.
In the 20 years I've been building web apps I've not once had to consider memory address limits. I am pretty sure the 500 page limit is for performance reasons.
fomb said:
scarble said:
The data in the database has to be loaded in to memory, at that point it stops being a database and just becomes data in memory, with a pointer and a variable type and a length.
Databases store data, then an application comes along and talks to the database, gets some data from it then does stuff with the data from the database, in memory.
The data in the database has limits defined not for the database but for when it's being used outside the database.
Sure - but you don't load the entire DB into memory - just the bits you need, so the size of PH is irrelevant. Do you think Google loads the internet into RAM when you query that?Databases store data, then an application comes along and talks to the database, gets some data from it then does stuff with the data from the database, in memory.
The data in the database has limits defined not for the database but for when it's being used outside the database.
MissChief said:
Do you enter the Lottery? And if so how many lines? Wednesday and Friday? Euromillions too? Actually none of that matters because it's random chance.
Well, not strictly true. If I enter two different lines I double my chances of winning down to a almost feasible 1 in 7 million.StevieBee said:
Why is the BBC so obsessed with Cricket?
I accept that there are many that like the game but I can't help thinking that the level of coverage they give it is entirely out of kilter with the numbers of people that actually give a toss (no pun intended).
Why do you think the BBC are obsessed with cricket? They don't have the rights to show any games on TV but do cover them on the radio. I suppose at the moment they will be covering more than normal as the Cricket World Cup is on. Conveniently though there is very little other sport on at the moment (bar the Six Nations but that is at weekends).I accept that there are many that like the game but I can't help thinking that the level of coverage they give it is entirely out of kilter with the numbers of people that actually give a toss (no pun intended).
StevieBee said:
More people pay to go and watch motor sport in the UK than cricket by a very considerable margin so why so much coverage?
Is that true? Please share your figures.fomb said:
MissChief said:
Do you enter the Lottery? And if so how many lines? Wednesday and Friday? Euromillions too? Actually none of that matters because it's random chance.
Well, not strictly true. If I enter two different lines I double my chances of winning down to a almost feasible 1 in 7 million.[quote=ralphrj
MIntel.StevieBee said:
More people pay to go and watch motor sport in the UK than cricket by a very considerable margin so why so much coverage?
Is that true? Please share your figures.The only report I have at the moment is from 2002: Leading circuit operators in the motor sports sector in terms of admissions, 1998-2002
This showed a total of 2.15million people paid to watch motor sports in the UK in 2002. IIRC, Cricket was around 1.2m. I'll dig out later reports and report back!
StevieBee said:
The only report I have at the moment is from 2002: Leading circuit operators in the motor sports sector in terms of admissions, 1998-2002
This showed a total of 2.15million people paid to watch motor sports in the UK in 2002. IIRC, Cricket was around 1.2m. I'll dig out later reports and report back!
I think that there might be a big difference between the 2002 figures and 2015 figures.This showed a total of 2.15million people paid to watch motor sports in the UK in 2002. IIRC, Cricket was around 1.2m. I'll dig out later reports and report back!
In terms of cricket, 2002 was the last year of the old B&H Cup which was then replaced with the Twenty20 Cup. That competition proved a lot more popular with the public and saw attendances increase dramatically. In addition the England cricket team was at that point still in the doldrums but post the 2005 Ashes crowds have been much higher. Also, some of the money from the sale of TV rights to Sky has been distributed around the test venues to increase the capacity of the grounds which supports the theory that attendances are increasing.
All in all I would expect cricket attendances to be significantly higher now than 13 years ago.
On the other hand I suspect that motorsport has gone in the other direction, mainly as a result in the decline in popularity of rallying. The RAC Rally used to be the biggest spectator event in the UK with estimates of 750,000 people attending. I suspect that the current figures are underwhelming as a result of the shorter format, the relocation to Wales, the drop in the number of manufacturers competing and the loss of Burns and McRae.
Whilst not quite the same measure as attendance figures it is worth considering the difference in value of the broadcasting rights to cricket and F1. Sky have the rights to both F1 and the England cricket matches. The actual figures are confidential but are thought to be in the region of £70m a year for the cricket and £20m a year for the F1. Admittedly the F1 deal is not exclusive but if it were the cost would be approximately £40m so still considerably less than the cricket.
DervVW said:
BlackVanDyke said:
How can the entire neighbourhood know about a nasty drug dealer and yet they still be plying their trade and enjoying their freedom?
cynical says they are being watched for bigger fishPH cycnical says because the police are out catching innocent motorists for... things
She's 30 now, but they've been that way since she started High School, she knows the names of the people who live there, everyone who lives there does, she knows they're drug dealers, everyone who lives there knows they are, but it seems they've been allowed to carry on like this for 20 years or more. My Wife has been told they get away with it by grassing up other, small time dealers to the Police and either the Police turn a blind eye to them or worse they hold some sort of unwritten 'get out of jail free card' given to them by a judge or something - it's a theme I've seen in UK crime fiction - but it seems insane to me - I know the 'war on drugs' was / is a stupid policy, but that doesn't mean we as a society should allow people like this to carry on because "well someone has too".
I have to assume it's less 'Hollywood' than that and they've simply not been stupid enough to get themselves arrested for anything and as such the Police are unable to investigate them.
Gassing Station | The Lounge | Top of Page | What's New | My Stuff