Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #6 > unrolled thread

Re: Accessing 2 tables having same name but different databases ms-access

Back to article view | Back to comp.lang.java.databases

Contents

  Re: Accessing 2 tables having same name but different databases ms-access David Lee Lambert <davidl@lmert.com> - 2011-04-25 08:15 -0700
    Re: Accessing 2 tables having same name but different databases ms-access Lew <noone@lewscanon.com> - 2011-04-25 15:54 -0400
      [OT] Conversation threading (was: Accessing 2 tables having same name but different databases ms-access) Stanimir Stamenkov <s7an10@netscape.net> - 2011-04-27 08:32 +0300
        Re: [OT] Conversation threading (was: Accessing 2 tables having same name but different databases ms-access) Martin Gregorie <martin@address-in-sig.invalid> - 2011-04-27 11:51 +0000
          Re: [OT] Conversation threading Lew <noone@lewscanon.com> - 2011-04-27 08:28 -0400
            Re: [OT] Conversation threading Martin Gregorie <martin@address-in-sig.invalid> - 2011-04-27 12:52 +0000
              Re: [OT] Conversation threading Daniele Futtorovic <da.futt.news@laposte-dot-net.invalid> - 2011-04-27 20:25 +0200
          Re: [OT] Conversation threading Daniele Futtorovic <da.futt.news@laposte-dot-net.invalid> - 2011-04-27 20:28 +0200

#6 — Re: Accessing 2 tables having same name but different databases ms-access

What do you mean "no result"?  Does "next()" return false for both rs2_1 and rs?

If you're really trying to improve response time, you should probably be running the two queries in separate threads ... but as you acknowledge, Access may not have as high performance as other RDBMSs.  You would also see reliability advantages by switching to something else.

--
DLL

[toc] | [next] | [standalone]

#7

David Lee Lambert wrote:
> What do you mean "no result"?  Does "next()" return false for both rs2_1 and rs?

David, please do NOT respond to Usenet posts with an email to 
"xxx@googlegroups.com", nor in such a way as to create a "Reply-To:".  It 
fragments the conversation and is insufferably rude.  Just use regular reply 
to the newsgroup so that the headers align.  Ok, please?  No more rudeness?

--
Lew
Honi soit qui mal y pense.
http://upload.wikimedia.org/wikipedia/commons/c/cf/Friz.jpg

[toc] | [prev] | [next] | [standalone]

#9 — [OT] Conversation threading (was: Accessing 2 tables having same name but different databases ms-access)

Mon, 25 Apr 2011 15:54:00 -0400, /Lew/:
> David Lee Lambert wrote:
>
>> What do you mean "no result"? Does "next()" return false for both
>> rs2_1 and rs?
>
> David, please do NOT respond to Usenet posts with an email to
> "xxx@googlegroups.com", nor in such a way as to create a
> "Reply-To:". It fragments the conversation and is insufferably rude.
> Just use regular reply to the newsgroup so that the headers align.
> Ok, please? No more rudeness?

Lew, the problem with conversation fragmentation on your side comes 
from Thunderbird's default settings [1], also.  David's reply has 
correct In-Reply-To header, but then doesn't include References 
header as it comes from some mail gateway rather than being sent by 
a proper News client.  Still having proper In-Reply-To should be 
enough to have a correct threading, given the original is also 
present in the thread.

Try setting your "mail.strict_threading" to false, then rebuild the 
group index ("Repair Folder" from the "Folder Properties" dialog on 
SeaMonkey - I guess it should be similar for Thunderbird), to see if 
it helps.

[1] 
<https://wiki.mozilla.org/MailNews:Message_Threading#mail.strict_threading>, 
<http://kb.mozillazine.org/Stop_threading_by_subject>

-- 
Stanimir

[toc] | [prev] | [next] | [standalone]

#10 — Re: [OT] Conversation threading (was: Accessing 2 tables having same name but different databases ms-access)

On Wed, 27 Apr 2011 08:32:25 +0300, Stanimir Stamenkov wrote:

> Try setting your "mail.strict_threading" to false, then rebuild the
> group index ("Repair Folder" from the "Folder Properties" dialog on
> SeaMonkey - I guess it should be similar for Thunderbird), to see if it
> helps.
>
IME Thunderbird sucked as a USENET client (though that was a while back. 
It was unstable too.), so I'd recommend:

- Pan if you're running Linux

- Forte's Agent if you're running Windows.
  Agent and Free Agent are the same except that the killfile
  doesn't work with Free Agent, but the upgrade to Agent only costs
  30 bux for a license code.

- Pan if you're running OS X.

 
-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |

[toc] | [prev] | [next] | [standalone]

#11 — Re: [OT] Conversation threading

On 04/27/2011 07:51 AM, Martin Gregorie wrote:
> On Wed, 27 Apr 2011 08:32:25 +0300, Stanimir Stamenkov wrote:
>
>> Try setting your "mail.strict_threading" to false, then rebuild the
>> group index ("Repair Folder" from the "Folder Properties" dialog on
>> SeaMonkey - I guess it should be similar for Thunderbird), to see if it
>> helps.
>>
> IME Thunderbird sucked as a USENET client (though that was a while back.
> It was unstable too.), so I'd recommend:
>
> - Pan if you're running Linux
>
> - Forte's Agent if you're running Windows.
>    Agent and Free Agent are the same except that the killfile
>    doesn't work with Free Agent, but the upgrade to Agent only costs
>    30 bux for a license code.

Right, so because someone else uses a sucky interface, I have to change what 
software I use?

*There's* a cooperative response!

David Lee Lambert is the one who needs to post properly.  I don't need to turn 
my life upside-down to accomodate his rudeness; I can simply killfile him, and 
anyone else who thinks we should jump through hoops to accommodate putzes. 
Thunderbird handles that just fucking fine, thank you very much.

-- 
Lew
Honi soit qui mal y pense.
http://upload.wikimedia.org/wikipedia/commons/c/cf/Friz.jpg

[toc] | [prev] | [next] | [standalone]

#12 — Re: [OT] Conversation threading

On Wed, 27 Apr 2011 08:28:18 -0400, Lew wrote:

> Right, so because someone else uses a sucky interface, I have to change
> what software I use?
>
You can do what you like, but there are much better newsreaders than 
Thunderbird: the main point of my post was to let folk know that, not to 
tell yo what to do. You take to much on yourself, sirrah. I've tried 
quite a few newsreaders over the years and I reckon Forte's Agent is 
easily best of breed among the Windows crop. I'd still be using it if 
there was a Linux port: since there isn't, I find Pan suits my needs.

I didn't like Thunderbird because:

- it didn't have a killfile system that was worth using

- it periodically lost track of its spellcheck dictionaries, at which
  point spell checking refused to work until it was deleted and 
  reinstalled.

- less frequently it corrupted its message store and, again,
  fixing that required removal and reinstallation. 
 

-- 
martin@   | Martin Gregorie
gregorie. | Essex, UK
org       |

[toc] | [prev] | [next] | [standalone]

#440 — Re: [OT] Conversation threading

On 27/04/2011 14:52, Martin Gregorie allegedly wrote:
> On Wed, 27 Apr 2011 08:28:18 -0400, Lew wrote:
>
>> Right, so because someone else uses a sucky interface, I have to change
>> what software I use?
>>
> You can do what you like, but there are much better newsreaders than
> Thunderbird: the main point of my post was to let folk know that, not to
> tell yo what to do. You take to much on yourself, sirrah. I've tried
> quite a few newsreaders over the years and I reckon Forte's Agent is
> easily best of breed among the Windows crop. I'd still be using it if
> there was a Linux port: since there isn't, I find Pan suits my needs.
>
> I didn't like Thunderbird because:
>
> - it didn't have a killfile system that was worth using
>
> - it periodically lost track of its spellcheck dictionaries, at which
>    point spell checking refused to work until it was deleted and
>    reinstalled.
>
> - less frequently it corrupted its message store and, again,
>    fixing that required removal and reinstallation.

Martin, I for one thank you for your input and shall put your suggestion 
to test forthwith.

-- 
DF.
An escaped convict once said to me:
"Alcatraz is the place to be"

[toc] | [prev] | [next] | [standalone]

#441 — Re: [OT] Conversation threading

On 27/04/2011 13:51, Martin Gregorie allegedly wrote:
> On Wed, 27 Apr 2011 08:32:25 +0300, Stanimir Stamenkov wrote:
>
>> Try setting your "mail.strict_threading" to false, then rebuild the
>> group index ("Repair Folder" from the "Folder Properties" dialog on
>> SeaMonkey - I guess it should be similar for Thunderbird), to see if it
>> helps.
>>
> IME Thunderbird sucked as a USENET client (though that was a while back.
> It was unstable too.), so I'd recommend:
>
> - Pan if you're running Linux
>
> - Forte's Agent if you're running Windows.
>    Agent and Free Agent are the same except that the killfile
>    doesn't work with Free Agent, but the upgrade to Agent only costs
>    30 bux for a license code.
>
> - Pan if you're running OS X.

Shoot. Forté has discontinued the free version...

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.java.databases

csiph-web