"Jeroen Braun" <jnjbraun@euronet.nl> wrote in message news:<3e72995a$0$57483$1b62eedf@news.euronet.nl>.. .
> It does not sound very normalized
The table was not built by me. I was told to use it as is.
> Have you considered using stored procedures?
You mean to dynamically generate the SQL in a stored procedure and run
it? I have though about this but I never had time to research it. I
am a bit of a novice when it comes to stored procedures but I'll give
it a try. Thanks.
> "T.Taylor" <taylort2@juno.com> schreef in bericht
> news:d0e1989e.0303141310.3ac49f1d@posting.google.c om...
> > I am only using one table that has over 70 columns and I am using ASP
> > to build the SQL dynamically.
> >
> > I created a clustered index for the most search for fields (16). Then
> > I created indexes for the rest of the fields. After I did this, my
> > queries seem to run a bit faster. Now I installed Full Text Search
> > and I am waiting for the catalog to be populated. Thanks.
> >
> >
> >
> >
> > "Mark Cohen" <markspam2@elcom.com.au> wrote in message
> news:<3e686ade$1_1@news.iprimus.com.au>...
> > > Hey
> > >
> > > I had to write a mosterous search across a whole set of tables, the
> search
> > > had about 40 parameters, and across far more rows. I found the best way
> to
> > > run it is to index the database really well, prepare a set of views to
> be
> > > used in the searching, and then dynamically build the search query in VB
> so
> > > that the where clause doesn't have 35 lines of additional tests saying
> WHERE
> > > field like @parm OR @parm IS NULL.
> > >
> > > Mark
> > >
> > >
> > > "T.Taylor" <taylort2@juno.com> wrote in message
> > > news:d0e1989e.0302240932.2d63b69e@posting.google.c om...
> > > > I have a table with over 70 fields and 300,000+ records. On the main
> > > > search page, the user can search by one of more fields. The target
> > > > page parses the form variables and create the sql statement, executes
> > > > it, then displays the results. My problem is that searches take a
> > > > long time to be completed or times out. Here is an example of what I
> > > > am talking about:
> > > >
> > > > Select * from myTable where name = 'abc%'
> > > >
> > > > Queries like this would take a very long to complete or timeout in an
> > > > ASP page and I was wondering how can I speed them up?
> > > >
> > > >
> > > > Thanks in Advance.