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.
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sql table running slow in sql server

    i have a table called Newdata in the batadase in sql server but it run really slowlly and sometimes times out on viewing the rows its only got 717 records in it. any idea or suggestions as to y its runing slowlly?


    thanks for the help
    Spoooooooon

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    maybe it's because it is dyslectic --> batadase.

    I think we need to see some code to answer that

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    the error messge i get is:

    [Microsft][ODBC SQL Server Driver][BDNETLIB]ConnectionRead (recv())
    [Microsft][ODBC SQL Server Driver][BDNETLIB]General network error. Check your newtwork documentation.
    [Microsft][ODBC SQL Server Driver]Timeout expired
    Last edited by Bluemonkey; 10-27-2003 at 11:49 AM.
    Spoooooooon

  • #4
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    cheers for the help
    Spoooooooon

  • #5
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    yes I am dyslexic actually, thanks for pointing it out....
    Last edited by Bluemonkey; 10-27-2003 at 11:30 AM.
    Spoooooooon

  • #6
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hey, sorry if i offended you.

    Is it only his one query that times out?

  • #7
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thats just on a simple return all rows of table from the menu option. but it gives the first few rows ok then as u scroll down it locks up so is it possiable to have a recod corrupted.?

    dont worry about u didnt offend me
    Spoooooooon

  • #8
    Regular Coder
    Join Date
    Mar 2003
    Posts
    241
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If you have lots of columns and rows it could run slow, but I doubt you have *that* many.

    If you have the possibility to log on to the database-machine and run the query, does it still give you this error ?

    Have you checked th logfiles[event viewer] on the database-server, maybe it is badly loaded ? Any error-messages ?
    Last edited by Caffeine; 10-27-2003 at 01:01 PM.

  • #9
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Originally posted by Bluemonkey
    thats just on a simple return all rows of table from the menu option. but it gives the first few rows ok then as u scroll down it locks up so is it possiable to have a recod corrupted.?
    So some of the records are printed? So the problem appears when you process the recordset ?

  • #10
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    the program it self locks up its done it a few times but ever single time. It happens when i scroll throw the record set in the enterprise manager program
    Spoooooooon

  • #11
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Strange.

    If your current query is
    select * from table
    then change it to
    select top 50 * from table order by ID
    (where ID is the primary key variable (or choose any other variable))

    If this goes through, then use
    select top 100 * from table order by ID
    and so on to pinpoint the records where it goes wrong

  • #12
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    a goo dplan ill give it a go
    cheers
    Spoooooooon

  • #13
    Senior Coder
    Join Date
    Jun 2002
    Location
    41° 8' 52" N -95° 53' 31" W
    Posts
    3,660
    Thanks
    0
    Thanked 0 Times in 0 Posts
    sounds like you need more memory on your computer... lol?
    Former ASP Forum Moderator - I'm back!

    If you can teach yourself how to learn, you can learn anything. ;)

  • #14
    Regular Coder
    Join Date
    Jun 2002
    Location
    England, Hythe
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I recon it might be a memory thing but strange only on this table ??? I did what raf said to do and it all read it fine but it started to struggle when you scroll by holing down on the scroll bar and jumping a head. But as I said I haven’t had that problem in any of my other DB's with 4000+ records but in this table it sticks and freezes the enterprise manager. Its odd
    Spoooooooon

  • #15
    Regular Coder
    Join Date
    Mar 2003
    Posts
    241
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It could be the hdd that is letting you down. I once had a hdd that had some bad sectors on it, and when I tried to open files that used those sectors, the program hang and sometimes windows crashed...

    I had to format the hdd to get the bad hdd confirmed, when I ran scandisk in windows it only said it could not complete the scan, even if I ran it for hours. And of course, I could not backup my files that were on those bad sectors, because the hdd could not read them!


  •  
    Page 1 of 2 12 LastLast

    Posting Permissions

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