Click here to Skip to main content
15,918,123 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: bug tracking system Pin
Colin Angus Mackay10-Feb-05 6:04
Colin Angus Mackay10-Feb-05 6:04 
GeneralRe: bug tracking system Pin
Luis Alonso Ramos14-Feb-05 19:42
Luis Alonso Ramos14-Feb-05 19:42 
GeneralWhidbey Gridview Pin
mav07079-Feb-05 11:15
mav07079-Feb-05 11:15 
Generaldatabase permissions problems Pin
Meanwhile8-Feb-05 7:53
Meanwhile8-Feb-05 7:53 
GeneralRe: database permissions problems Pin
JKroschel14-Feb-05 6:38
JKroschel14-Feb-05 6:38 
GeneralProblem with Javascript Pin
dotnetquery7-Feb-05 17:49
dotnetquery7-Feb-05 17:49 
GeneralSQL Server 2000 benchmarks for web. Pin
The Saint7-Feb-05 11:58
The Saint7-Feb-05 11:58 
GeneralRe: SQL Server 2000 benchmarks for web. Pin
Colin Angus Mackay10-Feb-05 6:09
Colin Angus Mackay10-Feb-05 6:09 
The Saint wrote:
If I were to compare one record against the universe, how much time would I take using SQL Server 2000.

Do you mean: How long would it take to retrieve one row from a table using SQL Server 2000?

It depends on a number of factors. The size of the rows, the index you are using in the filter (the WHERE clause of the SQL statement) or even if there is an index, disk contention (the HDD is a shared resource, other applications will be using it, along with potentially other users of the database) and so on.

If you want to gauge performance of your database then you just have to measure it. Certain things will obviously speed things up. e.g. Placing an index on the columns you are searching on will speed up SELECT statements. Removing indexes will speed up INSERT statements. You have to balance your needs.


Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums


GeneralExecute an exe file in ASP or javascript Pin
Member 17135757-Feb-05 4:08
Member 17135757-Feb-05 4:08 
GeneralRe: Execute an exe file in ASP or javascript Pin
alex.barylski11-Feb-05 10:46
alex.barylski11-Feb-05 10:46 
GeneralForms Pin
Brendan Vogt6-Feb-05 22:52
Brendan Vogt6-Feb-05 22:52 
GeneralRe: Forms Pin
basementman10-Feb-05 5:59
basementman10-Feb-05 5:59 
GeneralSearching between 2 date Pin
asta lavista6-Feb-05 14:08
asta lavista6-Feb-05 14:08 
GeneralRe: Searching between 2 date Pin
Yulianto.6-Feb-05 18:17
Yulianto.6-Feb-05 18:17 
Generalcreating database from my application Pin
Member 17123636-Feb-05 8:00
Member 17123636-Feb-05 8:00 
GeneralTextbox with dropdownmenu in webform Pin
Robert19744-Feb-05 9:20
Robert19744-Feb-05 9:20 
GeneralRe: Textbox with dropdownmenu in webform Pin
alex.barylski6-Feb-05 11:12
alex.barylski6-Feb-05 11:12 
GeneralRe: Textbox with dropdownmenu in webform Pin
Robert19747-Feb-05 0:48
Robert19747-Feb-05 0:48 
GeneralUsing Google Search Engine Pin
kanid4-Feb-05 1:06
kanid4-Feb-05 1:06 
GeneralUTF8 Encoding Pin
jan larsen3-Feb-05 23:34
jan larsen3-Feb-05 23:34 
GeneralSearching between 2 date Pin
asta lavista3-Feb-05 19:27
asta lavista3-Feb-05 19:27 
GeneralRe: Searching between 2 date Pin
shaiba4-Feb-05 3:46
shaiba4-Feb-05 3:46 
GeneralRunning Number Pin
asta lavista3-Feb-05 17:25
asta lavista3-Feb-05 17:25 
GeneralRe: Running Number Pin
Yulianto.3-Feb-05 17:58
Yulianto.3-Feb-05 17:58 
GeneralRedirect users to webmail Pin
langhal13-Feb-05 11:00
susslanghal13-Feb-05 11:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.