Off Topic (1 Viewer)

Lager? Pils? Ale?
 
How is it a conservative like you can live in California??
 
1674825202588.png
 
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
 
CJ_London said:
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
Click to expand...
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. :)
 
Subject post has been moved to "Theory and practice of database design." Credited to SachAccess.
 
@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.
 
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.
 
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.
 
Isaac said:
suspension-of-disbelief things like people with special superpowers
Click to expand...

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.
 
You must log in or register to reply here.

Similar threads

X
When was my Worker's Last Day Off?
Replies
3
Views
178
MarkK
MarkK
P
Why we were forced to Jab & Mask
Replies
10
Views
266
Isaac
Isaac
K
Using continuous forms instead of creating controls:)
Replies
3
Views
185
Pat Hartman
P
A
Restrictions Update Message
Replies
17
Views
272
Gasman
Gasman
Uncle Gizmo
Articles???
Replies
0
Views
86
Uncle Gizmo
Uncle Gizmo

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
Back
Top Bottom