Off Topic (1 Viewer)

[NauticalGent]

Lager? Pils? Ale?

 

[AccessBlaster]

Lager? Pils? Ale?

Ale, California Ale. I try to support my state when I can, it's pretty good if you could get your hands on one

 

[NauticalGent]

How is it a conservative like you can live in California??

 

[AccessBlaster]

How is it a conservative like you can live in California??

Weather is the short answer, the vibe is part of it. I've been in So Cal my entire life, nothing compares at any price.


Fun fact: I used to be a conservative democrat

 

[moke123]

 

[Steve R.]

 

[CJ_London]

Sorry, don't have time to trawl through 45 minutes of video. If you want a specific comment, please provide the time in the video where the author makes this assertion.

Certainly indexing can slow the bulk insert and update of records since the indexes need to be updated as well. But manual entry of data will not be noticeably affected. There are ways to overcome this which may or may not have been mentioned by the author.

However that small time cost of inserting/updating records is more than outweighed by the time saved when retrieving data.

see this link on why indexing is important

Why indexing is important for good performance

Indexing is essential for the efficient retrieval of data from a db. Some may be concerned about the additional disk space required for the index(es) - but disk space is cheap and they do not take up that much space. For small db's - a few '000 records per table and simple queries it is...

www.access-programmers.co.uk

 

[AccessBlaster]

@SachAccess this part of the forum is mostly political or non-technical. I will flag a mod to hopefully get your video moved to a better place.

@The_Doc_Man

 

[SachAccess]

Sorry, don't have time to trawl through 45 minutes of video. If you want a specific comment, please provide the time in the video where the author makes this assertion.

Certainly indexing can slow the bulk insert and update of records since the indexes need to be updated as well. But manual entry of data will not be noticeably affected. There are ways to overcome this which may or may not have been mentioned by the author.

However that small time cost of inserting/updating records is more than outweighed by the time saved when retrieving data.

see this link on why indexing is important

Why indexing is important for good performance

Indexing is essential for the efficient retrieval of data from a db. Some may be concerned about the additional disk space required for the index(es) - but disk space is cheap and they do not take up that much space. For small db's - a few '000 records per table and simple queries it is...

www.access-programmers.co.uk

Thanks for the help. Actually the entire video is of the same these, about index and its impact of performance.
If you get time, you may try to watch from minute 36:00.

Have a nice day ahead.

 

[The_Doc_Man]

I CAN move posts, but I'm not sure WHERE to move THIS post. Does anyone have a suggestion as to where it belongs?

 

[Steve R.]

I CAN move posts, but I'm not sure WHERE to move THIS post. Does anyone have a suggestion as to where it belongs?

The concern appears to be "indexing":

the author says, indexing can impact performance in negative way

Given that, perhaps the sub-forum "Theory and practice of database design" would be the most appropriate place to discuss the theory and practices of "indexing" in designing a database.

 

[The_Doc_Man]

Subject post has been moved to "Theory and practice of database design." Credited to SachAccess.

 

[AccessBlaster]

State of the Union Address preview

 

[Steve R.]

 

[Steve R.]

Courtesy of my eldest daughter.

 

[The_Doc_Man]

@Steve R. - not only does Brian Herbert ra** his father's corpse, but he needs help to do it. Which means he's not much of a writer.

 

[Pat Hartman]

I loved the first book. Hated the movie. It was like having a black cloth over my eyes so that it was impossible to see what was going on. Very bad interpretation.

 

[Isaac]

I usually dislike all movies that I very broadly (to the chagrin of many people) categorize as Cartoons, or suspension-of-disbelief things like people with special superpowers - i.e., 96.4% of the movie theaters today.

Thus I have taken to reading again.

 

[The_Doc_Man]

suspension-of-disbelief things like people with special superpowers

Yet there is one book that many people read and even hold in reverence where you need to do exactly that.

I hope I don't have to spell it out for you.

 

[AccessBlaster]

Who knew