|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
September 1st, 2004, 09:34 PM
|
|||
|
|||
|
SELECT Statement
Hi,
I have a table Jobs with the following fields id_jobs char(8), job_title char(100), job_desc char(1000), id_country, id_skills, id_industry the table has 40 records when i issue a select statement in my SP. SELECT id_jobs, job_title, job_desc, id_country, id_skills, id_country FROM jobs ... it took me more that 1 min to load the first 10 records. compared with this statement SELECT id_jobs FROM jobs .... this code is being called from my ASP Page. We have a shared hosting of db Hoping for your insights.! Thanks, Wendell
|
|
#3
September 3rd, 2004, 01:49 AM
|
|||
|
|||
|
its the job_title and job_desc i think that's causing the bottleneck.. why is this happening?
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > SELECT Statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
