Blog
Developers
Careers
Support
Contact
Gossamer Threads
Solutions
Results
About
Mailing Lists
Resource Centre
Forum
Tools
Home
Who's Online
Tags
Favourites
Login
Forum Search
(
Advanced Search
)
This forum
This category
All forums
for
Home
:
Products
:
DBMan SQL
:
Discussion
:
Re: [TheStone] Unable to compile ... home.pm line 1044
Previous Thread
Next Thread
Print Thread
View Flat
Nov 1, 2001, 11:46 AM
ktt
Novice
(29 posts)
Nov 1, 2001, 11:46 AM
Views: 7653
Shortcut
Re: [TheStone] Unable to compile ... home.pm line 1044
In reply to
For performance reasons in large tables i would recommand
Code:
my $count = $sql->table('Sample')->count();
This should provides the same result as
Code:
my $sth = $sql->table('Sample')->select();
return $sth->rows;
without the need to slurp in the complete table.
Subject
Author
Views
Date
Unable to compile ... home.pm line 1044
Super
7895
Oct 31, 2001, 1:59 PM
Re: [Super] Unable to compile ... home.pm line 1044
Paul
7754
Oct 31, 2001, 2:03 PM
Re: [RedRum] Unable to compile ... home.pm line 1044
Super
7780
Oct 31, 2001, 2:09 PM
Re: [Super] Unable to compile ... home.pm line 1044
Paul
7765
Oct 31, 2001, 2:12 PM
Re: [RedRum] Unable to compile ... home.pm line 1044
Super
7731
Oct 31, 2001, 2:30 PM
Re: [Super] Unable to compile ... home.pm line 1044
Bearwithme
7706
Oct 31, 2001, 2:35 PM
Re: [Bearwithme] Unable to compile ... home.pm line 1044
604
7769
Oct 31, 2001, 2:39 PM
Re: [TheStone] Unable to compile ... home.pm line 1044
Paul
7777
Oct 31, 2001, 2:48 PM
Re: [RedRum] Unable to compile ... home.pm line 1044
Alex
7729
Oct 31, 2001, 4:06 PM
Re: [Alex] Unable to compile ... home.pm line 1044
Paul
7671
Oct 31, 2001, 4:13 PM
Re: [TheStone] Unable to compile ... home.pm line 1044
ktt
7653
Nov 1, 2001, 11:46 AM
Re: [Super] Unable to compile ... home.pm line 1044
Alex
7725
Oct 31, 2001, 2:55 PM
Re: [Alex] Unable to compile ... home.pm line 1044
Bearwithme
7736
Oct 31, 2001, 3:22 PM
Re: [Bearwithme] Unable to compile ... home.pm line 1044
Super
7734
Oct 31, 2001, 3:27 PM
Re: [Bearwithme] Unable to compile ... home.pm line 1044
Alex
7712
Oct 31, 2001, 4:07 PM
Re: [Alex] Unable to compile ... home.pm line 1044
Bearwithme
7649
Nov 1, 2001, 4:30 AM
Re: [Alex] Unable to compile ... home.pm line 1044
Alex
7720
Oct 31, 2001, 6:19 PM
Re: [Alex] Unable to compile ... home.pm line 1044
TheFox
7645
Nov 1, 2001, 6:11 PM
Previous Thread
Next Thread
Print Thread
View Flat