Nicky: I had already suggested that, but he wasn't sure if checking if a
column is either 0 or 1 is faster than whether null or not null. He also
thought of a computed column that would assign 0 or 1 if the date was filled
in, but again he wasn't sure if it was faster
Karen
On Friday, June 20, 2025 at 10:46:57 AM CDT, 'Nicky Avery' via RBASE-L
<[email protected]> wrote:
Doug,
Sorry I missed the datatype of your LabelsPrintedDTS col. yesterday (hat tip,
Karen)!
I may be flogging a dead horse here but might you not simply add an integer
column with a default value of 0 and update it to 1 after you print? So now you
would use ... WHERE checkcolname = 0 for your selection.
Nicky
On 6/20/2025 7:57 AM, 'Karen Tellef' via RBASE-L wrote:
But you're missing Doug's problem, Dan. In order to populate the temp table,
he would have to say "where Datecol is null", because those are the records
that haven't been printed yet. And Doug is saying that the "is null" is really
slow
Karen
On Friday, June 20, 2025 at 09:53:20 AM CDT, 'Daniel Goldberg' via
RBASE-L <[email protected]> wrote:
For my warehouse team, i create a temp table, open a form, and they double
click or type in the part#s they want to print. Then the labels print based on
the temp table.
No extra columns for your permanent tables and super fast.
Dan Goldberg
From: [email protected] <[email protected]> On Behalf Of Doug
Hamilton
Sent: Friday, June 20, 2025 7:46 AM
To: [email protected]
Subject: [EXTERNAL] Re: [RBASE-L] - Speeding up SELECT WHERE ColName IS NULL
That would work, Buddy. Remember this column is not indexed, so the questions
becomes:
What SELECTs multiple rows faster - a specific value or a null value?
Which is what Nicky's approach was asking.
Doug
On 6/18/2025 4:30 PM, 'Buddy Walker' via RBASE-L wrote:
Doug
What I have done in the past was set the default value to some off the date
like 12/31/1899 then print your labels where the date = 12/31/1899
Buddy
Sent from my iPhone
On Jun 18, 2025, at 4:41 PM, 'Karen Tellef' via RBASE-L
<[email protected]> wrote:
Nick: His LabelsPrintedDTS field is a DATETIME or DATE, as far as I can tell
Karen
On Wednesday, June 18, 2025 at 03:36:00 PM CDT, 'Nicky Avery' via RBASE-L
<[email protected]> wrote:
On Wednesday, June 18, 2025 at 02:31:55 PM CDT, Doug Hamilton
<[email protected]> wrote:
Labels to be printed are selected WHERE LabelsPrintedDTS IS NULL.
Doug, when you create a new order, had you tried assigning a default value of
0 to LabelsPrintedDTS rather than no value? Once printed, you can change it to
1. This way you search on ... WHERE LabelsPrintedDTS = 0 rather than NULL.
Nicky
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/dedc6469-0161-4ea0-b20d-c43b8e7a3e4e%40wwavs.com
.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/893739093.98776.1750279295341%40mail.yahoo.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/114B88D7-E622-451B-9415-F9CB7C27413C%40comcast.net.
|
|
Virus-free.www.avast.com
|
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/fd90a573-442a-44eb-94af-16bfefaaea4c%40wi.rr.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB502744F408B9A21959DBB452D47CA%40BY3PR19MB5027.namprd19.prod.outlook.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1953759253.630007.1750431450360%40mail.yahoo.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/50d79aab-52f6-44ec-8045-6cc6e2559172%40wwavs.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1169643246.647323.1750435013601%40mail.yahoo.com.
