corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » General Chat » AutoTrader - Looks like a cool place to work!


New Topic
New Poll 		  <<  1    2  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author AutoTrader - Looks like a cool place to work!
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
6th Apr 17 at 13:05   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by DaveyLC
specific manufacturer optional items as that would just be barmy for something like Autotrader!


They'd need to start with that because part of the problem is sellers wouldn't list stuff at that level of detail.

Also not that barmy when you consider what the buyer will be searching for - many know what they want.
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
6th Apr 17 at 13:43   View User's Profile U2U Member Reply With Quote
BTW you mentioned storage.. BIT shifting over using BOOLEAN is far more efficient because of one main reason.. The smallest field size in SQL/MSQL is 1 BYTE even a BOOLEAN/BIT flag uses 1 BYTE so within that 1 BYTE you could actually store a combination of store 8 options rather than 1.

16 Options as BOOLEAN fields would occupy 16 bytes of raw storage where as using BIT shifting those same 16 bytes could store a combination of 128 options.
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
6th Apr 17 at 14:08   View Garage View User's Profile U2U Member Reply With Quote
Yeah assuming you could get the data to not waste bits once you stored it.
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
6th Apr 17 at 14:21   View User's Profile U2U Member Reply With Quote
You either use a dynamic VARBINARY(MAX) container or make sure the field type is the right size for the largest combination, worst case scenario is you waste 7 bits
DaveyLC
Member
Registered: 8th Oct 08
Location: Berkshire
User status: Offline
6th Apr 17 at 14:24   View User's Profile U2U Member Reply With Quote
... To be fair a BIGINT is 8bytes which would give 64 options that would be great for something like Autotrader that is listing generic things like:

Metalic Paint
Electric Seats
SatNAv

etc.
etc.
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
6th Apr 17 at 17:50   View Garage View User's Profile U2U Member Reply With Quote
Yeah although I wasn't looking to process the manufacturer data in any way, just store it. So their keys in the DB would drop straight in to the sales data. Really all you're doing is marrying up the sales list with existing data rather than trying to describe the sales cars more exhaustively.
kz
Member
Registered: 9th Aug 02
Location: Southend, Essex Drives: Mini Cooper S
User status: Offline
7th Apr 17 at 22:01   View User's Profile U2U Member Reply With Quote
Fuck this thread turning boring.

Best search parameter of AutoTrader is 'model variant' it's so helpful.

I also like search by acceleration but it's a shame there's only a choice of 4 different ones and not whatever you want.
Graham88
Member
Registered: 16th Apr 07
Location: South East Kent Drives: E46 M3
User status: Offline
9th Apr 17 at 00:49   View User's Profile U2U Member Reply With Quote
I'm not surprised they can afford lovely offices when they charge the price that they do!

  <<  1    2  >>
New Topic
New Poll

Corsa Sport » Message Board » General Chat » AutoTrader - Looks like a cool place to work! 22 database queries in 0.0095751 seconds