Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Wildcard freeze

  1. #1
    New Coder
    Join Date
    Jun 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wildcard freeze

    wildcard * before a search string generates a Table scan in the database, locking ALL records for ALL other uses causing everything to hang until the search is complete.

    How can you make a web database search more effective?

  • #2
    Regular Coder
    Join Date
    Jul 2002
    Location
    Raleigh, NC
    Posts
    484
    Thanks
    0
    Thanked 0 Times in 0 Posts
    have you tried indexing the fields that will be searched?
    -WebMark Art
    Programming is 80% thinking and 20% spelling

  • #3
    New Coder
    Join Date
    Jun 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    indexing?

    Its just one big old comma daliminated file.
    how would you index that and how could that effectivly help?????

  • #4
    New Coder
    Join Date
    Jun 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    never mind

    apparantly

    Full text indexes are not updated more then once a day or so, even then
    its not 100% so you can search for a product one day, find it, next day
    it wont show... Its good for finding "almost everything"


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •