Listing all shows A-Z

[gEd]

Sorry if this is a dumb question but is there an easy way that SearchWiz can just bring up all shows in alphabetical order.

I tried adding a search filter where "a" is in the title but pvrx2.exe went to 100% cpu and memory consumption went through the roof.

Code:

2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: OnUiClick()- {X=12.5, Y=22.04861}
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: OnUiClick()- cmdMenuButtons
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: Controls_OnKeyDown()- MenuButton - Search
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: CreateProgramList- ENTER - for: a
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: ClearProgramsList()- Executed.
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: ClearSearchResults()- Called.
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: ClearProgramTimesList()- Executed.
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: GuideSearch()- criteria: a
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: ClearSearchResults()- Called.
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: BuildProgramArray()- requested for: a
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: BuildProgramArray()- sql: SELECT p.oid, p.name as name, description, rating, count(*) as numShows FROM PROGRAMME p, CHANNEL c WHERE (p.name like '%a%' )  AND p.end_time >= '2008-01-03 20:48:02.00' AND p.channel_oid = c.oid AND c.name in ('BBC1', 'BBC2', 'ITV1 London', 'Channel 4', 'Five', 'UKTV History', 'BBC3', 'BBC4', 'ITV2', 'ITV3', 'ITV4', 'Film4', 'Dave') GROUP BY p.name;
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: OpenSqlReader- statement: SELECT p.oid, p.name as name, description, rating, count(*) as numShows FROM PROGRAMME p, CHANNEL c WHERE (p.name like '%a%' )  AND p.end_time >= '2008-01-03 20:48:02.00' AND p.channel_oid = c.oid AND c.name in ('BBC1', 'BBC2', 'ITV1 London', 'Channel 4', 'Five', 'UKTV History', 'BBC3', 'BBC4', 'ITV2', 'ITV3', 'ITV4', 'Film4', 'Dave') GROUP BY p.name;

[JavaWiz]

Sorry if this is a dumb question but is there an easy way that SearchWiz can just bring up all shows in alphabetical order.

I tried adding a search filter where "a" is in the title but pvrx2.exe went to 100% cpu and memory consumption went through the roof.

Code:

2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: OnUiClick()- {X=12.5, Y=22.04861}
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: OnUiClick()- cmdMenuButtons
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: Controls_OnKeyDown()- MenuButton - Search
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: CreateProgramList- ENTER - for: a
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: ClearProgramsList()- Executed.
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: ClearSearchResults()- Called.
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2: ClearProgramTimesList()- Executed.
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: GuideSearch()- criteria: a
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: ClearSearchResults()- Called.
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: BuildProgramArray()- requested for: a
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: BuildProgramArray()- sql: SELECT p.oid, p.name as name, description, rating, count(*) as numShows FROM PROGRAMME p, CHANNEL c WHERE (p.name like '%a%' )  AND p.end_time >= '2008-01-03 20:48:02.00' AND p.channel_oid = c.oid AND c.name in ('BBC1', 'BBC2', 'ITV1 London', 'Channel 4', 'Five', 'UKTV History', 'BBC3', 'BBC4', 'ITV2', 'ITV3', 'ITV4', 'Film4', 'Dave') GROUP BY p.name;
2008-01-03 20:48:02.031    VERBOSE    [1]    SearchWizX2.core: OpenSqlReader- statement: SELECT p.oid, p.name as name, description, rating, count(*) as numShows FROM PROGRAMME p, CHANNEL c WHERE (p.name like '%a%' )  AND p.end_time >= '2008-01-03 20:48:02.00' AND p.channel_oid = c.oid AND c.name in ('BBC1', 'BBC2', 'ITV1 London', 'Channel 4', 'Five', 'UKTV History', 'BBC3', 'BBC4', 'ITV2', 'ITV3', 'ITV4', 'Film4', 'Dave') GROUP BY p.name;

Not sure why the program responded that way, I'll take a look tonight and see if I can replicate.

Looks like you only had a channel filter and a search string of 'a', correct?

[gEd]

correct. I selected all channels in the config and when running SW, selected "a" in the title.

[JavaWiz]

I've run the same query on my machine. I selected approx 30 channels and retrieved all programs starting with A.

• Memory started at approx. 526 mb
  
• CPU pegged at 100% while query ran (approx 6-8 seconds)
  
• Memory peaked at approx. 644 mb
  
• The query returned 841 shows
  
• Memory settled back to approx. 537 mb

I noticed according to your sig, you only have 512mb of memory, I suspect you may be swapping heavily when doing the search.

Another thing, your query looks for 'A' ANYWHERE in the title, not just at the beginning. You may want to modify your range filter to "BEGINNING of any Search By Field". This will retrieve ONLY the programs beginning with A in the title.

Do you notice this behavior when you run other searches, or only when you attempt to retrieve a large amount of data?